I have two sheets (tabs) on the Google Sheets filem which Jotforms inte

  • Profile Image
    Paul Thompson
    Asked on November 21, 2019 at 10:17 AM

    I have two sheets (tabs) on the Google Sheets filem which Jotforms integrates with. One to receive data from the form and the other to process it and format cells differently, for users to function with. I want to hide the integration sheet so that users only see the sheet they are to use.

    Is it possible to do this and still receive the data from Jotforms to the hidden sheet?



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

  • Profile Image
    IvayloK
    Answered on November 21, 2019 at 11:58 AM

    In order to prevent the integration to break, we do not recommend even slight changes on the sheet integrated with the form.

    Please note that the integration may break, if you do any changes to the spreadsheet.

    You need to keep the header part of the spreadsheet where the field labels are placed intact. Modifying any part of the header will break the integration.

    So, we would not recommend your workaround.