Extra columns in a spreadsheet...

  • jenloch
    Asked on July 22, 2014 at 5:05 PM

    When integrated with Google Spreadsheets, I want the form data to enter into the correct columns in the spreadsheet, but I also want to add other columns to that same spreadsheet for our internal use. For instance these are customers creating a Return Merchandise Authorization and I want to add a column to record if/when we've received their returned item. Can I add other columns in the spreadsheet and will it still work correctly, or will the form data not enter into the spreadsheet correctly if I do that?

  • Jeanette JotForm Support
    Replied on July 22, 2014 at 11:43 PM

    I just made some test too see if it won't brake the integration, and as far as I can see, it doesn't

    So, it should work with no problem

    Extra columns in a spreadsheet Screenshot 20

  • jenloch
    Replied on July 23, 2014 at 3:37 PM

    I created a test form to test it, and it is not working. Once I added a new column as the first column and submitted the form again, the submissions are not going into the form now.

  • David JotForm Support
    Replied on July 23, 2014 at 4:42 PM

    Hi,

    As my colleague stated, it does break the integration, but it could be causing errors when trying to forward the data when it finds a new field in the spreadsheet where it expected a different one.  I would try removing and re-doing the integration once the spreadsheet is fully setup.  If this still does not work, please let us know and we will be happy to look into this further.

    Thank you for using Jotform!