Can the spreadsheet that is created by the jot form be broken out?

  • TMyersRandstad
    Asked on July 17, 2017 at 12:16 PM

    I have several entries put on this jot form monthly and I would like the take the old entries and move them to a new sheet in the workbook and only have the entries for a given month be on current worksheet "sheet1" that is being captured.

    I want to take everything from row 131 and up and move it to a newly created sheet (sheet2) and only have the entries for the current month on sheet 1.

    Will this break anything if I do that?  Can this be done?

    Jotform Thread 1200941 Screenshot
  • Welvin Support Team Lead
    Replied on July 17, 2017 at 1:36 PM

    We don't recommend doing any modification in the Google Spreadsheet file if you are referring to this integration. If it's the excel file that is generated when you click on the Excel download button, then that's fine. 

    You may consider moving the Data into a different spreadsheet file via the ImportRange feature (https://support.google.com/docs/answer/3093340?hl=en). 

    Or, you may consider downloading the submissions as an excel file the delete the submissions keeping the newest ones.

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel