Auto-update Google Spreadsheet integration when a new field is added to the form

  • Profile Image
    Cincinnati_Incorporated
    Asked on August 20, 2019 at 03:26 PM

    I have read several posts about adding fields to a form with google sheets integration.

    In testing I have found that if I add a field to the form and name a column in the sheet exactly the same as the form, it seems to work ok.

    However, I have not tested this fully and want to know if the current best solution is to remove the integration and re-add or is adding a column to the spreadsheet ok?

  • Profile Image
    JohnRex
    Answered on August 20, 2019 at 04:41 PM

    Yes, you were right.

    Re-integration creates another spreadsheet with all the submissions in it.

    So in case you don't want to re-integrate the form but adding a field is necessary, you can do so but you need to also update the column headers of the integrated spreadsheet every time you add a field inside the form. Ensure that the field labels has its corresponding column in the spreadsheet.

    Though we are not encouraging this method to users, doing a re-integration in case new fields are added to the form is always the safest way for this.