Is it Possible to add a new sheet to the integrated spreadsheet

Is it Possible to add a new sheet to the integrated SpreadSheet so I can work with data there not modifying the destination sheet, also can I load all my processing code to the app script editor in the same SS? Can this affect the reception of JotForm submissions???

Yes. Actually we recommend this if you want to add modification or customization to your spreadsheet data. You should not alter directly the Sheet being used by your form in google spreadsheet integration.

Create instead a new separate Sheet in the spreadsheet where you can manipulate the data. You can use the Import function of google spreadsheet also.

Let us know if you need further assistance.

Thank you, I am rebuilding the whole system, copying secondary sheets and code, disabled temporaly the form, and using the query() function to select the columns the application needs to process data based a time trigger, we made a test, and Jotform recorded the submission correctly on the destination sheet, we are going to put it up to production soon.

Thank you so much

Claudio

Thank you for updating us on the status.

I have also trigger a refresh to the spreadsheet submissions of your forms. All submission data of the form should be push to the Sheet in your google spreadsheet being used by your form.

Let us know if there are missing submissions or if submission update are not being push to the Sheet.