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 Sheets integration has stopped working

    Asked by gotonovy on June 20, 2017 at 08:24 PM

    I just have an issue at the moment where the integration from my form to Google Sheets has stopped working.

    All the previous submissions have come through fine, although any new ones as of 20/06/17 have stopped coming through. I can still see the new submissions through JotForm, but they haven't appeared on the sheet.

    I have added 3 columns at the end of the spreadsheet. I'm not sure whether this has affected it? I haven't changed anything else.

    The form I'm using is https://form.jotform.co/71552646575868

    Any help on this would be appreciated

    Thanks

    Page URL:
    http://www.northerncyc.com/book_in.html

  • Profile Image
    JotForm Support

    Answered by EltonCris on June 20, 2017 at 11:38 PM

    Yes, that's definitely the reason why it has stopped from working.

    When I tried to sync your submissions with your Google Spreadsheet, it prompted this error. This most likely happened when the integrated spreadsheet was edited.

    Unfortunately, we do not recommend editing the integrated spreadsheet. Chances are it would break the integration.

    If you want to add something to the spreadsheet, you can do it on a separate tab sheet.

    Thanks

  • Profile Image

    Answered by gotonovy on June 21, 2017 at 09:12 AM

    Thanks for your reply. I have now redone the integration of the form and have not added any columns, just editing the data in a few cells, yet I am still getting this issue.

    What else is causing this problem? Are you not able to change the text in individual cells? I'm sure it worked last year when I did the same thing.

  • Profile Image
    JotForm Support

    Answered by BDAVID on June 21, 2017 at 12:30 PM

    I just also tried to push the missing submissions manually, but an error occurred:

    Please remove the integration, and integrate back-again, this time do not do a single edit on the newly integrated spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Also, if you still need to apply some edits in the spreadsheet, you can use the import range feature to pull the data from the integrated spreadsheet into a new one, in that way the integration will remain intact, and you can customize the new one.