Google Spreadsheet is missing some data

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?
...
- google spreadsheet
- missing data
JotForm Support

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.
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
...
JotForm Support

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!