Data not populating integrated Google Spreadsheet correctly

  • Profile Image
    alphaemc
    Asked 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?

  • Profile Image
    Boris
    Answered 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.