What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Extra columns in a spreadsheet...Asked by jenloch 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?
JotForm Support Manager
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
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.
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!