Google Spreadsheet is missing some data | JotForm

Login
Username
Password
Forgot password?
Forgot Password? Enter your username or email
Go back
Sign Up
Username
Email
Password
Confirm Password
I agree to the Terms of Use and Privacy Policy.
By clicking "Create My Account" you agree our Terms of Use and Privacy Policy.

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!