Extra columns in a spreadsheet...

  • Profile Image
    Asked on July 22, 2014 at 05: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?

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

  • Profile Image
    Answered on July 23, 2014 at 03: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.

  • Profile Image
    Answered on July 23, 2014 at 04:42 PM


    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!