JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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 Sheets integration missing submissions & delayed submissions.Asked by Tshwanechess 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
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.
Thanks for the reply, it seems we'll have to adjust our approach a bit then.