What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by Austin_Residence 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
    JotForm Support

    Answered by Welvin 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

    Answered by Austin_Residence 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
    JotForm Support

    Answered by Welvin 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

    Answered by Austin_Residence on April 20, 2017 at 01:13 PM

    Thanks!