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

  • Profile Image
    Austin_Residence
    Asked 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? 

    Thanks, Alex

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

    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.

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

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

    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. 

  • Profile Image
    Austin_Residence
    Answered on April 20, 2017 at 01:13 PM

    Thanks!