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

    Data not populating integrated Google Spreadsheet correctly

    Asked by alphaemc on December 17, 2016 at 04:22 AM

    I created a JotForm that I integrated with a Google Spreadsheet. However, the last piece of data collected on the form does not record to the correct cell in the linked spreadsheet (see Linked Google Spreadsheet image attached). How do I fix this?

    Page URL:
    https://form.jotform.com/63503281747154

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Boris on December 17, 2016 at 12:06 PM

    Thank you for providing that image, I see that either your spreadsheet or your form have been modified after you've set up the integration.

    The header in column I should state "Amt. Collected From", and header "Cash Applied" should be in column J. I see from the screenshot that your spreadsheet is missing the "Amt. Collected From" header, so that "Cash Applied" appears in column I on your end.

    This is how the headers should display:

    To resolve the issue, I would recommend removing your current integration and its integrated spreadsheet, and then setting up the integration freshly again:

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    This will ensure that all your columns are correctly created, and represent the fields that currently exist on your form.

    Please do try it out, and let us know should you experience any further troubles after that. Thank you.