What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Cloning a Form Should Not Brake the Google Spreadsheet Ingteration of the Original FormAsked by firstname.lastname@example.org on May 19, 2014 at 02:15 PM
Encountered some of the problems that were mentioned a year ago on this post: http://www.jotform.com/answers/252891-PROBLEMS-with-Google-Spreadsheet-integration-Not-updating-data
I integrated the Google spreadsheet for my form at http://email@example.com/plc. It worked seamlessly for the first two weeks, but this weekend it stopped working. We've had 5 more entries in the past 3 days and none of them have appeared on the Google sheet.
Normally the sync between submissions and sheet is rapid, so I know it's not lag. I suspect that what happened is related to CLONING FORMS. Friday evening I cloned the form to modify into a different survey. I noticed that when you clone a sheet it also clones the integrations--so I strongly suspect that Google spreadsheets got confused trying to sync data of two forms into one sheet, and so it quit syncing for both.
Have you looked into this possibility?
It's true, cloning a form inside your account also clones the integration and it creates troubles with the original integration that stops updating properly. But by removing and adding a new integration the problem is solved.
In order to update the Spreadsheet with the missing submissions you can download your submissions in excel format:
Then going into your Google Spreadsheet and import the data:
I can forward this to our developers so they can analyse better this situation and decide whether to change this cloning property.
They will notify you via this thread once they have an update on this.
Please get back to us if further support is needed.
We have disabled integrating Google Drive and Spreadsheets while cloning a form. Could you please let me know if you still experience any issues?