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 Spreadsheets: Submissions are not updating

    Asked by gshlomi on March 02, 2015 at 09:17 AM

    Hi , 

    I notice that Submissions not updating our google sheet since 3/2/2015 

    Please see if you can help and restore the Submissions

     

    Thanks 

    Page URL:
    http://www.jotform.me/gshlomi/itform

    not updating submissions google spreadsheets spreadsheets google integration
  • Profile Image
    JotForm Support

    Answered by Jan on March 02, 2015 at 11:36 AM

    Hello,

    The integration usually stops for 2 reasons, there could be an issue with Google API or you made some changes on the spreadsheet columns and headers.

    Please take note that when you integrate JotForm to Google spreadsheet, the spreadsheet columns are generated based on the form fields questions. It means that when you change something on the form, you will need to integrate the spreadsheet again. Also, you should not make changes on the spreadsheet because the integration will stop working or that specific field will be blank.

    I cloned your form and integrate with my Google spreadsheet and it works fine. Please try to remove the integration and add it again.

    Hope this works. If not, let us know so that we can further investigate.

    Thank you.

  • Profile Image

    Answered by gshlomi on March 03, 2015 at 05:18 AM

    Hi ,

    I try to disconnect and connect again 

    the system creates new sheet with the submissions but only until 3/2/15 all the other submissions

    are not in the sheet  

  • Profile Image

    Answered by gshlomi on March 03, 2015 at 06:05 AM

    You can see submission ID 300586585981649970

    I can see it in the sheet but without data 

  • Profile Image
    JotForm Support

    Answered by Jan on March 03, 2015 at 08:30 AM

    Hi there,

    It will really create a new spreadsheet once you redo the integration. The old spreadsheet should still be on your Google Drive if you need to back it up.

    The submission is blank probably because the form fields within JotForm and header columns within spreadsheet did not match.

    Please try these steps:

    1. Remove the integration then save the form.

    2. Log out from JotForm.

    3. Clear your browsers cache.

    4. Close and re-open your browser

    5. Log back in to JotForm.

    6. Add the integration again.

    I will also clear your forms cache so you forms will be refreshed from our servers.

    Let us know if it is still the same. Thank you.

  • Profile Image

    Answered by philipp  on April 09, 2015 at 08:22 AM

    Hi,

    I have a similar problem and a question concerning the steps to reintegrate the spreadsheet again. Will my older submissions be exported in the Google spreadsheet again after I deleted the old spreadsheet connection? Or do I have to copy them into the new spreadsheet manually?

     

    Thanks

    philipp

  • Profile Image
    JotForm Support

    Answered by Jan on April 09, 2015 at 10:26 AM

    Hi philipp,

    In order to assist you properly, I created a separate thread for  your issue.

    This is the URL/ link of the new thread: http://www.jotform.com/answers/549177

    Thank you for understanding.

  • Profile Image

    Answered by graham1370 on September 07, 2016 at 06:06 PM

    You look like a smart kid Jan, but you're barking up the wrong tree. Integration between Jotform and Google has broken down as of Sep 7th 2016. And it is possible to mess with a few things within the google spreadsheet without having to always remove the link then reestablishing it again to jotform, which as you say creates a completely new sheet.

  • Profile Image
    JotForm Support

    Answered by david on September 07, 2016 at 06:33 PM

    The integration should be working properly once again.  Any new submission will update the sheet with all current submissions.  All new submissions should be forwarded to the appropriate sheet immediately after receiving the submission.