- sanpedroAsked on August 23, 2017 at 02:20 PM
- JotForm SupportjonathanAnswered on August 23, 2017 at 02:24 PM
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.
- sanpedroAnswered on August 23, 2017 at 02:31 PM
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
- JotForm SupportjonathanAnswered on August 23, 2017 at 02:47 PM
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.