- Austin_ResidenceAsked on April 20, 2017 at 09:43 AM
Now, I just noticed that the Google spreadsheet that's integrated, is showing the TREC License # that's been submitted for the last two form submissions, but for all the previous submissions, the TREC license # does not appear in the spreadsheet. What would cause that and how can I ensure that all license numbers are properly recorded on my integrated spreadsheet going forward?
- JotForm SupportWelvinAnswered on April 20, 2017 at 09:52 AM
It looks like you have removed the previous field. Please note that deleting a field will also delete its data in the form submissions page. If you want to retrieve the old data, you need to revert your form to the earlier version.
After that, just add the number field again and configure it according to your current settings. You can hide the old TREC field so that won't show up in the form. You'll be missing the TREC numbers on the two new submissions. At least, you're just missing two, not all.
- Austin_ResidenceAnswered on April 20, 2017 at 09:55 AM
thanks.. I actually think I would be okay just starting fresh... is there a way to clear the integrated spreadsheet now or in the future / periodically when I want to start off with a blank spreadsheet? for example, if I want to start off with a clean blank spreadsheet at the start of every year?.. thanks
- JotForm SupportWelvinAnswered on April 20, 2017 at 11:13 AM
You have to delete the data in the form submissions page as well as in the spreadsheet file. But I would suggest making a copy of the original form and start anew using the cloned form.
This way, the form and its data will be saved as well as the spreadsheet file that is connected to it.
- Austin_ResidenceAnswered on April 20, 2017 at 01:13 PM