Adding columns to a Google Sheet integration

  • quizmeisters
    Asked on August 13, 2019 at 8:07 PM

    Hi,

    We'd like to use the Google Sheet integration for one of our forms to collate other data. We have edited this form to add 3 extra columns and now the form responses are not populating the sheet.

    We haven't edited any of the information/column headers on the form responses.

    If we reintegrate this Google Sheet, can we add in the 3 extra columns without breaking the form responses? 

    Here's the form link: https://pages.quizmeisters.com.au/forms/end-of-show-report/

    Here's the Google Sheet link: https://docs.google.com/spreadsheets/d/1KMaRmijlHgopzCDR0hJQkzZ9ZBXCgug9soLomBKkFEY/edit#gid=0

    I look forward to hearing from you.

    Cheers,

    Bella

  • Elton Support Team Lead
    Replied on August 13, 2019 at 9:23 PM

    Hi Bella,

    Unfortunately, any small changes on the integrated sheet might break the integration so we do not recommend editing the integrated sheet. You may do it in a new sheet on the separate tab instead. Here's what I mean:

    Adding columns to a Google Sheet integration Image 1 Screenshot 20

    If you have also made changes on your form like adding, deleting fields, you have to re-integrate your form with Google Spreadsheet. This would create a new spreadsheet file with all your existing data loaded in it.

    If you have any questions, please let us know.

    Thank you!