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: submissions not updated in spreadsheet.

    Asked by nuparadygm on February 23, 2017 at 04:29 AM

    Same problem happened again, please check and rectify asap. We need a permanent solution for this, we can't keep de-integrate and re-integrate with google every time.

    Submissions not updated in Google Sheets (Private)

    Asked by nuparadygm on January 13, 2017 at 02:06 AM

    I've two almost identical forms (Sign In and Sign Out), both are integrated with Google Sheets. Sign In form is not able to update the submission to its google sheets, no problem to the Sign Out form. I tried reintegrate the Sign In form and submissions updated correctly but the subsequent submissions still not able to update.

    I tried using the same Sign In form and integrate with another google account, same problem (no update).

    And then i tried duplicate the Sign In form, Clone of Sign In form and integrate with my original google account. It worked.

    Look like the Sign In form might have problem.

    Please advise.

     

    Page URL:
    https://form.jotform.me/53090740128450

  • Profile Image
    JotForm Support

    Answered by Welvin on February 23, 2017 at 07:32 AM

    I have just manually forwarded the submissions to the integrated sheet. The success message appears which means that the integration is still working. Please monitor the form and the sheet and let us know if the issue persists. We can submit this to our developers if it's doing the same problem.

    Please note that sometimes, it's not a problem to our end but to Google Spreadsheet API itself. They are constantly making updates which are causing our integration to fail in some cases. Our developers can fix it, but sometimes, re-integration is also required. We will let you know, just in case.

    Note that if you want to use the same sheet when re-integrating, you can do this through Zapier. Zapier is free to use. You'll only need to upgrade if you want additional limits.

    https://zapier.com/zapbook/zaps/1924/add-new-jotform-submissions-to-a-google-sheets-spreadsheet/ 

  • Profile Image

    Answered by nuparadygm on February 23, 2017 at 08:06 AM

    The issue still persists after i re-integrated the form with google sheet.

  • Profile Image
    JotForm Support

    Answered by Welvin on February 23, 2017 at 09:17 AM

    Actually, I'm not suggesting you to redo the integration. But thank you for doing that. Would you mind sharing us the spreadsheet URL? You can just make it as a read only for us. We need to have the sheet so our developers can do their own test, to verify that the integration is no longer working.

  • Profile Image

    Answered by splintor on February 23, 2017 at 02:52 PM

    We encounter the same problem. Sheets integration used to work, and stopped recently - new submissions are no longer added to our sheet.
  • Profile Image

    Answered by splintor on February 23, 2017 at 02:54 PM

    (also, the support form won't let us send a question. When submitting, it says:
    Error Message

    Spam check has failed..

     

    )

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 23, 2017 at 05:10 PM

    @splintor, your question will be addressed on the following thread: https://www.jotform.com/answers/1074758 

  • Profile Image

    Answered by nuparadygm on February 23, 2017 at 06:26 PM
  • Profile Image

    Answered by nuparadygm on February 23, 2017 at 06:31 PM

    I have another similar form which working fine, https://form.jotform.me/53100701860442

    And its spreadsheet url is https://docs.google.com/spreadsheets/d/1rfVj_NIbLo54kJrb40KPVX3ZPr18INzELWEipBAQBKg/edit?usp=sharing

     

    You may take a look.

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 23, 2017 at 08:55 PM

    Thanks for sharing, I have cloned your form, but the issue did not reproduced, it updated the new entry intermediately to my integrated spreadsheet. I have forward this to our back-end team to get further help. You will be notified via this thread about any updates. 

  • Profile Image
    JotForm Developer

    Answered by Denis on February 24, 2017 at 03:33 AM

    Hello,

    Sorry for the trouble caused to you. Problem should be fixed now. I've sent missing data into your spreadsheet. Please test it and let us know if issue still persists. 

     

    Regards.

  • Profile Image

    Answered by nuparadygm on February 24, 2017 at 07:05 AM

    It is working now. Can Jotform provides a permanent solution for this issue? This issue occurred three times already. Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on February 24, 2017 at 09:00 AM

    Our backend team are doing their best to fix the problem permanently. However, as I've mentioned, it is sometimes not to our end but to Google Spreadsheet itself. If the problem happens again, make sure to let us know and please don't re-integrate until we advise you to do so.