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.
Google Spreadsheets: Submissions are not updatingAsked by gshlomi on March 02, 2015 at 09:17 AM
I notice that Submissions not updating our google sheet since 3/2/2015
Please see if you can help and restore the Submissions
not updating submissions google spreadsheets spreadsheets google integration
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.
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
You can see submission ID 300586585981649970
I can see it in the sheet but without data
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.
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.
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.
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.
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.