If I create a new sheet will it sync with the new records?

  • TMyersRandstad
    Asked on December 19, 2017 at 4:08 PM

    My form has over 1093 submissions.  I am getting an error when trying to open my sheet telling me that it is too big for my screen.


    IF I create another sheet within this workbook will jotform know how to put the new records on that sheet?


    Can I copy this sheet to another sheet and then delete all the records in this sheet to start fresh?

  • Richie JotForm Support
    Replied on December 19, 2017 at 5:01 PM

    I have checked your form, EMD Billing Form and can you provide a screenshot for the current error?

    You can create multiple sheets in your spreadsheet and reference data from one sheet to another. You can refer to this this article.

    https://support.google.com/docs/answer/75943?hl=en


    I hope this information helps.


  • TMyersRandstad
    Replied on December 20, 2017 at 10:26 AM

    1513783214jotform error Screenshot 10 The error I get when I open the spreadsheet created from my emdbilling form.   


    I want to rename the above sheet to something else and start a new Sheet1 within this same workbook.  When jotform populates a spreadsheet does it use "Sheet1" as an indicator for where to put the newest submissions.  Or if I rename this current workbook to something entirely different (i.e. Archive EMD Billing Form)  will jotform create a new spreadsheet entitled EMD Billing Form?

  • Richie JotForm Support
    Replied on December 20, 2017 at 11:04 AM

    First time seeing that error, maybe it's just suggesting so that its easy for you to see all data in a bigger screen.

    I have tested this and it will still push the submissions on your first sheet even if you rename your sheet.

    If I create a new sheet will it sync with the new records? Image 1 Screenshot 20