The TREC License field submissions are missing in the form submissions page

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? 

Thanks, Alex

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.

https://www.jotform.com/help/294-How-to-view-form-revision-history

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.

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

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.

https://www.jotform.com/help/27-How-to-clone-an-existing-form-from-your-account 

This way, the form and its data will be saved as well as the spreadsheet file that is connected to it. 

Thanks!