JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Google Spreadsheet: If I add a new field to my form already integrated with Google Spreadsheet. Do I need to re-integrate my form again?Asked by jonnavarra on March 01, 2016 at 10:39 AM
I added a text box in the middle of my form which is integrated to a spreadsheet.
When i test the form, the value on the new text box does not show in the spreadsheet.
Do I have to redo the integration or is there a way of just updating it?
Basically it is not needed to redo the Google Spreadsheet integration. The spreadsheet should update when the form is submitted.
If notice that it does not update after submission, please let us know so we can proceed to further troubleshoot.
I just did a little experiment. I edited the Submissions folder/sheet by renaming the heading on the new column to match the label on the form. It worked.
This I did not know- apparently the column header is checked against the incoming submission? Is that correct?
I renamed the column next to my new column and resubmitted... the renamed column did not get populated.
I have checked the integration and I found that you do not need to update the name in the spreadsheet.
As explained by my colleague above, it updates automatically, for example, if you have a field named "Text1" and integrated your form with Google Spreadsheet, then you rename the field to "Text2", the integration must still be working.
You can not rename the fields in the spreadsheet, it could break the integration, but you can rename the fields in your form and it will work.
Could you please try again?
Try renaming a field again without changing anything in your spreadsheet, you should receive your data normally.
I renamed the field on the spreadsheet to make it easier for me to identify in the sheet/code... but did not want the user to see it as such on the form... my mistake- I didn't know.
So it does some kind of label pairing/checking... I thought it'd have simply been positional.
All set... thanks
Great! Glad to know that it's now resolved. Thanks!