What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to integrate my form with an old Google Spreadsheet?

    Asked by s.schaper on October 26, 2015 at 07: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.

    JotForm how problem integrate integrated
  • Profile Image

    Answered by Carina 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:

    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.