Why I'm losing data in Spreadsheet?

  • Profile Image
    lindeymagee
    Asked on August 01, 2018 at 11:04 PM

    Hi again 

    We are still missing data in our Google spreadsheet, some from quite a while back. We were told that is b/c we are editing our spreadsheet, but we MUST be able to edit our spreadsheet because sometimes people move or their data otherwise changes. We need to be able to sort our spreadsheets in various ways, which is a type of edit according to Google.

    If we can't get this resolved, we are going to have to find another form builder that we can trust with our membership list. This is very important data to our organization. Apparently we have been losing data for a while now. 

    Also, what is involved in changing our account email? 

    Thanks.

  • Profile Image
    Nik_C
    Answered on August 02, 2018 at 02:26 AM

    Unfortunately, integration with Google Spreadsheet is not something that is controlled by us only, it comes from Google as well.

    We recommend that Spreadsheet is not edited, mostly not altered in terms of adding/removing columns/rows.

    Our integration will work best if you leave the spreadsheet as it is (without custom additions/formatting).

    At the end if direct integration doesn't suffice, you could try 3rd party integration with Zapier: https://zapier.com/apps/jotform/integrations/google-docs

    Let us know if that works for you.

    Thank you!