- canvashutAsked on September 05, 2013 at 05:42 AM
We've been trying to sync our new form to a Google Docs spreadsheet. We've used the wizard on the website to set it up and it works great at first.
After a day or 2, the sync seems to break and the spreadsheet fails to be updated when we get a submission through the form. We still get the usual email but the spreadsheet is not automatically updated and we have to cancel and restart the sync.
Is there anything we are doing wrong or anything we could look at? It's happened a few times now.
- JotForm Supportashwin_dAnswered on September 05, 2013 at 06:51 AM
I cloned your form and did integration with google spreadsheet. The submissions are accurately saved to google spreadsheet and the said problem doesn't occur.
Have you edited any of the header columns of your google spreadsheet? Editing the header columns will break the integration.
Please delete the said integration from your form, clear browser cache and re-integrate with google spreadsheet.
Upon taking a closer look at your spreadsheet url, if doesn't seems to be complete and re-integration should surely help.
Do let us know if the problem persist.
- canvashutAnswered on September 05, 2013 at 06:57 AM
Thanks for the reply.
We will resync the sheet and hopefully it will be ok again.
- canvashutAnswered on September 05, 2013 at 07:11 AM
Have resynced and It's working fine at the moment, but has done before and fails after a day or 2.
Just another question, If I edit the form (change an option or change some wording etc) do I need to resync? Also, If I were to add in a new question, would this require a resync?
- JotForm Supportashwin_dAnswered on September 05, 2013 at 08:00 AM
If you edit the form to add a new question it will break the integration and you should always re-integrate your form with your google spreadsheet.
The number of question in your form and the columns in google spreadsheet should always match for the integration to work.
In my understanding: if you update the label of any question in your form, the integration should be intact and it should work normally.
I hope this answers your question.