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

  • Profile Image
    TMyersRandstad
    Asked on December 19, 2017 at 04: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?

  • Profile Image
    Richie_P
    Answered on December 19, 2017 at 05: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.


  • Profile Image
    TMyersRandstad
    Answered on December 20, 2017 at 10:26 AM

    1513783214jotform error.PNG 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?

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