- gshlomiAsked 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
- JotForm SupportJanAnswered on March 02, 2015 at 11:36 AM
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.
- gshlomiAnswered on March 03, 2015 at 05:18 AM
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
- gshlomiAnswered on March 03, 2015 at 06:05 AM
You can see submission ID 300586585981649970
I can see it in the sheet but without data
- JotForm SupportJanAnswered on March 03, 2015 at 08:30 AM
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.
- philippAnswered on April 09, 2015 at 08:22 AM
- JotForm SupportJanAnswered on April 09, 2015 at 10:26 AM
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.
- graham1370Answered 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.
- JotForm SupportdavidAnswered 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.