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

    The spreadsheet is not being updated with new registered participants

    Asked by rjacomen on August 12, 2014 at 02:36 PM
    We are finding that the individual form is being sent to Google, but the spreadsheet is not being updated with new registered participants.  Is this a level of account issue, or is there an integration issue?
    google spreadsheet sheet not updating spreadsheet
  • Profile Image

    Answered by rjacomen on August 12, 2014 at 02:58 PM

    After repeating the integration process numerous times, the spreadsheets are still not updating with new incoming registered participants.  I am sharing the document with one other person via Google Drive.  I changed her settings to view only to ensure the documents are not being changed.  The spreadsheet is still not updating, but we are receiving the individual registration form in Google Drive.  

  • Profile Image
    JotForm Support

    Answered by Welvin on August 12, 2014 at 04:19 PM

    Hi,

    It's in the integration. You've mentioned that a new spreadsheet is created for each new submission. I think there's something in your form field labels that is causing this. Perhaps, a non-supported character. What is the form URL? Let us know so we check.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by Welvin on August 12, 2014 at 04:22 PM

    Okay, I checked your forms and they have the same format. Looking at it, please try to change your field labels such as:

    Full Name of School/Agency -> Full Name of School or Agency

    E-mail -> Email Address or Email

    Then re-integrate the form to Google Spreadsheet. Check if that resolves the issue.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by steve on August 12, 2014 at 09:09 PM

    Hello rjacomen,

    We had a system glitch that cause Google Spreadsheets integrations to temporarily stop working. It appears to have resolved itself. It may have been our server, the network, or Google's server. We see no further warnings in our log files and all our tests are working.

    If you do still encounter the issue with duplicate spreadsheets being created, please update this ticket along with the form ID where it's occurring. We do apologize for the inconvenience.

    Kind Regards

  • Profile Image

    Answered by rjacomen on August 26, 2014 at 10:51 AM
  • Profile Image
    JotForm Support

    Answered by Welvin on August 26, 2014 at 11:20 AM

    We'll be posting our reply to your new post here: http://www.jotform.com/answers/420582-Google-Integration-not-keeping-up-with-submissions#0.

    Thank you!