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?

  • jonnavarra
    Asked on March 1, 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?

     

  • Huberson
    Replied on March 1, 2016 at 12:34 PM

    Hi,

    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.

  • jonnavarra
    Replied on March 1, 2016 at 2:02 PM

    ok

    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.

  • Kevin Support Team Lead
    Replied on March 1, 2016 at 3: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. 

  • jonnavarra
    Replied on March 2, 2016 at 8: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

    Jon

  • Elton Support Team Lead
    Replied on March 2, 2016 at 10:19 AM

    Great! Glad to know that it's now resolved. Thanks!