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.


  • Profile Image

    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?

     

    Page URL:
    https://www.jotform.com//?formID=60567291746161

    integrated google spreadsheet integration
  • Profile Image

    Answered by Huberson 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

    Answered by jonnavarra 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
    JotForm Support

    Answered by Kevin_G 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

    Answered by jonnavarra 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
    JotForm Support

    Answered by EltonCris on March 02, 2016 at 10:19 AM

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