Broken column in Google Spreadsheet Integration

  • japanfukuoka
    Asked on April 13, 2016 at 8:03 AM

    I recently opened up a Google Spreadsheet that is integrated to a JotForm form (Name Tags) for the first time in a month or more. I noticed that the layout was different than previously, making it hard to work with (form submissions 1-5 are laid out horizontally in separate columns). I looked into the revision history and went back to the revision that had the desired layout (form submissions 1-5 are viewable in the same column). Other than the fact that I don't know how the layout changed suddenly, so far so good. I can still work with this.

    However, when I tested an order to confirm functionality, it failed to update a single column in the spreadsheet, the one that submits the last name of the person who ordered an item. All other information is updated in the spreadsheet normally. 

     

    How can I get the form to start submitting that information to the spreadsheet again?

    Jotform Thread 817255 Screenshot
  • Huberson
    Replied on April 13, 2016 at 10:59 AM

    Hello,

    If you have change the column name in the spreadsheet or modify the form column this will cause missing data in the spreadsheet. For example if you change 'First Name' to 'FirstName' or change the field it will break the column.

    To fix this you need to change the form back the way is was when you made the Integration. You can also remove and add the Integration back again.

    Do let us know if you need more assistance.

  • japanfukuoka
    Replied on April 13, 2016 at 7:31 PM

    Thank you for the advice, Huberson! I was able to fix it easily by changing the column heading to match the input field in the form.

  • jonathan
    Replied on April 13, 2016 at 10:32 PM

    Thank you for updating us on the status. We're glad to know all is good now.

    Feel free to contact us again anytime should you need our assistance.

    Cheers