Do any actions in an integrated Google sheet impact the integration?

  • Profile Image
    WTSDARegion8
    Asked on February 24, 2021 at 01:53 PM

    We had added some conditional formatting and added a couple additional columns in the Google Sheet to review the data coming from the Jotform and noticed that some of the columns were no longer being entered in the Google Sheet. In the Jotform table we had added two columns to split out two data points from a fill-in-the blank question.


  • Profile Image
    JohnRex
    Answered on February 24, 2021 at 08:23 PM

    Note that any changes you made inside the integrated Sheet will break the integration. The same with the form itself - when you make major changes such as deleting or adding new fields.

    We suggest it best to remove the current integration and re-integrate it with Google Sheet.

    If there's a need to customize the Sheet after integration, we recommend creating a copy of the original sheet and do the changes there. You can use the IMPORTRANGE function to achieve that.