-
quizmeistersAsked 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 LeadReplied 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:
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!