Google Spreadsheet is missing some data

  • travisfoote
    Asked on April 5, 2017 at 3: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?
    ...
  • Mike
    Replied on April 5, 2017 at 3: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.

  • travisfoote
    Replied on April 5, 2017 at 6:44 PM
    yes I renamed some columns to identify them easier. I had tested the
    spreadsheet after renaming them and it worked fine
    ...
  • Kiran Support Team Lead
    Replied on April 6, 2017 at 1: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!