Google Spreadsheet integration breaks when editing the data

mjjmk
Asked on February 17, 2018 at 06:56 AM

After editing the spreadsheet (just changing the name for a column) it no longer updates with new submissions. Is there a way I can change column names/delete specific response data without it dying?

This is a re-post of a comment on How to Integrate Forms with Google Sheets
Michael

Jotform Support

Answered on February 17, 2018 at 08:21 AM

We would like to apologize for any inconvenience. We do not encourage editing the Google Spreadsheet integrated with the form because it tends to break the integration. A workaround that you can do is to import the data from the original sheet into another sheet using IMPORTRANGE — https://support.google.com/docs/answer/3093340?hl=

Then, you can already alter the imported data in the new sheet.

If you have other questions, please do not hesitate to let us know.