- jonnavarraAsked 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?
- HubersonAnswered on March 01, 2016 at 12:34 PM
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.
- jonnavarraAnswered on March 01, 2016 at 02:02 PM
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.
- JotForm SupportKevin_GAnswered on March 01, 2016 at 03:37 PM
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.
- jonnavarraAnswered on March 02, 2016 at 08:32 AM
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
- JotForm SupportEltonCrisAnswered on March 02, 2016 at 10:19 AM
Great! Glad to know that it's now resolved. Thanks!