-
TMyersRandstadAsked 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 SupportReplied 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.
-
TMyersRandstadReplied on December 20, 2017 at 10:26 AM
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 SupportReplied 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.