Google Spreadsheet integration breaks when editing the data

  • mjjmk
    Asked on February 17, 2018 at 6: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?

  • Mike_G JotForm Support
    Replied on February 17, 2018 at 8: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.