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 failing

    Asked by enzomanolo on January 06, 2017 at 05:49 PM

    When I setup integration with google spreadsheet it works for a few submissions and then stops updating the spreadsheet. I have seen in your online forum that this is recurring problem.

    If I remove the integration on the form and then add it back, yes it will work again. I have seen this behavior with several but not all our forms (all cloned from each other). I have tried one of the recommended tips to edit a field name on the form but it did not make the form resync.

    I would love for broken links to be resynced because we must format the target spreadsheet (align left, auto-wrap and narrow the column width) so removing and reintegrating is NOT our preferred choice. We do NOT change any field text. I suspected formatting the target was the root cause so I tried to recreate a CLONE of a form and test new submissions after each format change but was not able to reproduce the problem (make it stop populating the target spreadsheet). It seems random.

    Here is the link to two of our broken forms:

    https://form.jotform.com/63506728875266

    https://form.jotform.com/63506226054248

    Here is a link of the CLONE that will not break (source form of the first link above). ;-)

    https://form.jotform.com/70056301341239

    Thank you!

     

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

  • Profile Image
    JotForm Support

    Answered by Kiran on January 06, 2017 at 11:13 PM

    We didn't notice any recent issues with Google spreadsheet integration and it should be working fine. Generally, the integration fails when there are any modifications made to the spreadsheet. Since you say that the integration is working fine with the cloned form, it may be a form specific issue. I have tried clearing the form caches of your account. Please try integrating Google spreadsheet again and see if that works.

    Let us know if you need any further assistance. We will be happy to assist.