How to integrate my form with an old Google Spreadsheet?

  • s.schaper
    Asked on October 26, 2015 at 7:02 AM

    Dear Support Team,

    Recently i have built a JotForm and integrated it with googlespreadsheets. I made some changes in the document and as of this morning i didn't see new submisions appear in the sheet (i did get e-mail confirmations). I figured i had to re-integrate the spreadsheet. But now it automatically made a new spreadsheet, losing all formulas of the old spreadsheet. The problem is that the old spreadsheet is shared with a number of people.

    So how do i get the integration back with the old spreadsheet and/or how can i tackle this problem?

    Kind Regards,


    Sander.

  • Carina
    Replied on October 26, 2015 at 11:05 AM

    Unfortunately the integration wizard creates automatically a new spreadsheet every time it is recreated so I believe it is not possible to connect the form with the old spreadsheet. 

    You can see here how to copy the formula. Also the sharing definitions will need to be recreated. 

    If you want to add old submissions to the spreadsheet you can first download the submissions in CSV format and then importing them to the Google Spreadsheet:

    How to integrate my form with an old Google Spreadsheet? Image 1 Screenshot 20

    https://support.airtable.com/hc/en-us/articles/203423579-Importing-a-spreadsheet-from-Excel-or-Google-Sheets 

    Let us know if we can assist you further.