Data Loss in Google Spreadsheet

  • Profile Image
    hugoleon46
    Asked on March 26, 2014 at 01:12 PM

    Hello.

    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.

    Hugo

  • Profile Image
    aytekin
    Answered on March 26, 2014 at 02:14 PM

    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. 

  • Profile Image
    hugoleon46
    Answered on March 26, 2014 at 04:24 PM

    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.

     

  • Profile Image
    jonathan
    Answered on March 26, 2014 at 05:18 PM

    Hi,

    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.

    Regards,