- iondjpAsked on March 16, 2018 at 11:22 AM
I had set-up google integration to send form data to spreadsheet. It was working fine. Yesterday I noticed new entries were not appearing in Google Sheets.
This Google spreadsheet has additional sheets with filter views and AutoCrat PDF scripts setup. So, I REALLY do not want to hear that I have to delete the connection and set this up again.
I didn't want to go into the JotForm Google integration for fear of 'breaking' the link.
Is there a way to know whether this is due to Google end or JotForm end?
Is it possible that I have not given enough time to see the updated test entry I created today?
- JotForm SupportAdrianAnswered on March 16, 2018 at 12:54 PM
Is this the form that you are talking about? https://form.jotform.com/70871013832249
Confirm this and we will try to resync the sheet.
Please note that making changes to your form such as changing the text of the questions or adding/removing a question will most likely break the integration.
Making changes to the integrated spreadsheet directly will break the integration as well.
- iondjpAnswered on March 16, 2018 at 02:57 PM
Yes that is the form.
That would explain it. I believe I have made changes before on JotForm end, but I did not have a problem.
I recently deleted some columns that were unrelated to jotform fields (they were added by AutoCrat). I suspect that may have been the cause.
I have more work to do on the form. Maybe it would be better if I waited before I got you to re-sync? Or, should we do it now?
- JotForm SupportWelvinAnswered on March 16, 2018 at 04:06 PM
I would suggest making the changes, then re-integrate Google Spreadsheet. You will be given a new sheet after re-integration. Re-syncing won't permanently fix the problem, so I would suggest doing that.
Also, if you plan to process the data to Google Spreadsheet, please use an ImportRange function to do it in another spreadsheet file.