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 Docs sync always unsyncing...

    Asked by canvashut on September 05, 2013 at 05:42 AM

    We've been trying to sync our new form to a Google Docs spreadsheet.  We've used the wizard on the website to set it up and it works great at first.

    After a day or 2, the sync seems to break and the spreadsheet fails to be updated when we get a submission through the form.  We still get the usual email but the spreadsheet is not automatically updated and we have to cancel and restart the sync.

     

    Is there anything we are doing wrong or anything we could look at?  It's happened a few times now.

     

    Thanks!

    Page URL:
    http://www.canvashut.com/pages/jobapp.php

    new form email Updated thanks
  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 05, 2013 at 06:51 AM

    Hello canvashut,

    I cloned your form and did integration with google spreadsheet. The submissions are accurately saved to google spreadsheet and the said problem doesn't occur.

    Have you edited any of the header columns of your google spreadsheet? Editing the header columns will break the integration. 

    Please delete the said integration from your form, clear browser cache and re-integrate with google spreadsheet.

    Upon taking a closer look at your spreadsheet url, if doesn't seems to be complete and re-integration should surely help.

    Do let us know if the problem persist.

    Thank you!

  • Profile Image

    Answered by canvashut on September 05, 2013 at 06:57 AM

    Thanks for the reply.  

    We will resync the sheet and hopefully it will be ok again. 

  • Profile Image

    Answered by canvashut on September 05, 2013 at 07:11 AM

    Have resynced and It's working fine at the moment, but has done before and fails after a day or 2.

    Just another question, If I edit the form (change an option or change some wording etc) do I need to resync?  Also, If I were to add in a new question, would this require a resync?

    Thanks

  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 05, 2013 at 08:00 AM

    Hello canvashut,

    If you edit the form to add a new question it will break the integration and you should always re-integrate your form with your google spreadsheet.

    The number of question in your form and the columns in google spreadsheet should always match for the integration to work.

    In my understanding: if you update the label of any question in your form, the integration should be intact and it should work normally.

    I hope this answers your question.

    Thank you!