What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Google Spreadsheet is missing some data

    Asked by travisfoote 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
  • Profile Image
    JotForm Support

    Answered by Mike 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

    Answered by travisfoote 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
    JotForm Support

    Answered by Kiran 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!