- TshwanechessAsked on October 12, 2016 at 06:11 PM
We've been having issues with our Google Sheets integrations. Sometimes submissions aren't sent to the Google Sheets and other times it takes up to 8 hours to reflect in the Google Sheets.
We do not change the names of the fields on the doc, but we do change the values stored in the fields as needed. Sometimes we also sort the values in a certain order and filter fields.
This has happened on multiple forms in the past but seems worse recently.
Are we doing something wrong?
The latest culprit is form id: 62643956423966
- JotForm SupportChriistianAnswered on October 13, 2016 at 01:35 AM
Unfortunately, modifying the spreadsheet such as editing the values stored in the fields can cause the Google Sheet integration to break. This may be why the submissions are not being sent to your Google Sheets file.
If the integration breaks, you can remove the google sheet integration and re-integrate it again. Doing this will create a new integrated sheet that will have all the previous submissions.
To prevent the integration from breaking again, I would recommend against editing the Google spreadsheet. If you want to make modifications, I suggest that you create a new spreadsheet and use the ImportRange function to import the data from the integrated sheet to the new sheet that you created. Any changes that you want to make should then be made in the new sheet. Here's a guide that can help: How To Import Data From Other Google Spreadsheets.
Please let us know if you need further assistance.
- TshwanechessAnswered on October 13, 2016 at 03:23 PM
Thanks for the reply, it seems we'll have to adjust our approach a bit then.