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?

  • Profile Image
    jonnavarra
    Asked 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?

     

  • Profile Image
    Huberson
    Answered on March 01, 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.

  • Profile Image
    jonnavarra
    Answered on March 01, 2016 at 02: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.

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

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

    Jon

  • Profile Image
    EltonCris
    Answered on March 02, 2016 at 10:19 AM

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