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

  • Profile Image
    sanpedro
    Asked on August 23, 2017 at 02:20 PM
    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???
  • Profile Image
    jonathan
    Answered 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.

  • Profile Image
    sanpedro
    Answered 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

    Claudio

  • Profile Image
    jonathan
    Answered 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.