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.
Data Loss in Google SpreadsheetAsked by hugoleon46 on March 26, 2014 at 01:12 PM
Yesterday something happened with my Google Spreadsheet integrated with my form. I had all the registrations (70+), but for some reason the registrations went back to 50+. It is very important to my client recover this information because the are paying for an event admission, is there a way to recover this data at least to yesterday?.
Please help me, it is very important. I already had a problem with data loss from submissions once, and this can't happen again.
Thanks in advance.
Submissions JotForm problem excel CSV
Note that if you delete an entry on Jotform submissions page it will also be deleted on your google spreadsheet. That's what might have happened.
You should also never edit that file manually. Your changes will be lost if you make modifications on the google spreadsheet file.
If you have the submissions on your JotForm Submissions page but not on the google spreadsheets, try deleting the google spreadsheets integration and then re-creating it. It should re-create the file with all entries.
I have deleted all of them once on Jotform Submissions Page and the integration still worked until yesterday. Also at the beginning i added two new columns and still worked well. So I'm really not sure where the integration breaks.
But it is important to mention the points you mention somewhere before we trust in the integration. I think it's not very reliable yet.
Jotform is a very nice tool, you have many options to setup quickly and easily a form, as a new premium user I see some opportunities to improve:
1) Dev team could respond faster with new features.
2) As you can see in the other question a mentioned, some people in the support team don't try things first before giving advice.
3) The submissions page must give us some options to export data. For example, I can't export incomplete payments, so if there are many, can't follow all the people who may have had a problem.
What I did now to solve this was:
1) Copying the original file (file1) to a new one (file2).
2) I got back to the revision that was OK on file1.
3) Copy and paste the new submissions from file2 to file1.
4) Backup both files.
Although currently do not know whether the new records will be entered correctly again with the spreadsheet integration. If its broken, will set it up again but at least have the total of submissions.
Thanks anyway aytekin. I'll keep you aware of what happens.
I have deleted all of them once on Jotform Submissions Page and the integration still worked until yesterday.
Just to clarify on this statement -- it is correct that integration will stay even if you delete the submissions data AND even the data on the google spreadsheet will remain (it actually becomes a backup copy also of the form's submissions)
BUT you have to know that deleted form submissions/data will be permanently deleted and cannot be restored via Jotform. IF you deleted the submissions and re-integrate to google spreadsheet, there will be no data that will be transferred to the google spreadsheet.
Also at the beginning i added two new columns and still worked well. So I'm really not sure where the integration breaks
Every time you integrate the form to google spreadsheet, it resets or create a new spreadsheet template. This means that any formatting/customization you did on an existing integrated spreadsheet will be wipeout on the newly created spreadsheet.
Mr. Aytekin have received your latest message and should be aware of your suggestions.
Thank you for taking the time to explain this thoroughly. We do always appreciate our users positive or even negative inputs for our own improvement.