Data not populating integrated Google Spreadsheet correctly

  • alphaemc
    Asked on December 17, 2016 at 4: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?

    Jotform Thread 1013995 Screenshot
    Page URL: https://form.jotform.com/63503281747154
  • Boris
    Replied 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:

    Data not populating integrated Google Spreadsheet correctly Image 1 Screenshot 20

    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.