Google Spreadsheet is missing some data

  • Profile Image
    travisfoote
    Asked on April 05, 2017 at 03:13 PM
    I have a separate issue with the same form. I had someone complete the form
    yesterday and it did not store all the form data in the google sheet. It
    was missing almost all the form field information they added including the
    attachments they uploaded. How do we get that checked?
    ...
  • Profile Image
    Mike
    Answered on April 05, 2017 at 03:27 PM

    Have you modified the Google Spreadsheet? The integration might not be friendly to the spreadsheet customizations (for example, if you moved some columns, renamed or deleted them).

    If you redo the integration, it should create a brand new spreadsheet with complete form data.

  • Profile Image
    travisfoote
    Answered on April 05, 2017 at 06:44 PM
    yes I renamed some columns to identify them easier. I had tested the
    spreadsheet after renaming them and it worked fine
    ...
  • Profile Image
    Kiran
    Answered on April 06, 2017 at 01:17 AM

    Unfortunately, any modifications made to the integrated spreadsheet will break the integration. Please remove the existing spreadsheet integration on the form and re-integrate again and it should be working fine. If you need to work on the data captured to the spreadsheet, it is recommended to copy the data to a different spreadsheet.

    Hope this information helps!