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

    Google Spreadsheet Integration not working

    Asked by RocketshipEd on March 01, 2016 at 05:42 PM

    Hello, I set up integration with google sheets for one form and it did not update with the last entry. How can we fix this?

    Page URL:
    https://form.jotform.com/60105409330139

    Screenshot
    google spreadsheet google integration spreadsheet reintegration
  • Profile Image
    JotForm Support

    Answered by jonathan on March 01, 2016 at 08:24 PM

    Please try first the re-integration process. That is:

    #1 Removed the existing Google spreadsheet 

     

    #2 Save the form

    #3 Redo the integration to Google Spreadsheet

    user guide: How-to-Integrate-Form-with-Google-Spreadsheet

    #4 Save the form.

    Now view your Google Docs spreadsheet and check if all the existing submission data of the forms were now fully copied.

    Let us know if issue persist.

    Thanks.

     

  • Profile Image

    Answered by RocketshipEd on March 02, 2016 at 02:02 PM

    I can do that, but the sheet is currently viewable by quite a few people in my organization. In addition, I've added different columns and rows. 

    Will the integration stop working if I make these changes again? I can't delete and re-invite folks to the sheet every time integration stops working.

  • Profile Image
    JotForm Support

    Answered by jonathan on March 02, 2016 at 04:55 PM

     but the sheet is currently viewable by quite a few people in my organization. In addition, I've added different columns and rows. 

    This could be causing the issue.

    Unfortunately, you cannot modify the integrated Submission spreadsheet. The changes you did on the Submission sheet must have broken the connection/integration which causes the submission to be not updating the sheet anymore.

    Will the integration stop working if I make these changes again? 

    You meant you will modify the Submission sheet after you have redo the integration right? The answer is Yes -- the integration will be broken again.

    If you want to apply customization the Submission sheet being used by the google integration, you need to make a copy of the  Submission sheet instead and do your customization outside the sheet being used by the integration. The Google spreadsheet have feature to import sheet to another sheet. You can work on the copied sheet instead.

    Hope this help. Please let us know if you need further assistance on this.