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

    How do I archive old submissions from 2013; not discard but archive for later retrieval?

    Asked by purpledragonhq on March 01, 2016 at 02:10 PM
    Submissions archive old archive data
  • Profile Image
    JotForm Support

    Answered by Nik_C on March 01, 2016 at 03:44 PM

    Hi, you can do this by going to my forms. Select the form you want to archive.

    Click on More button and choose Archive Form. Form will disappear from MY FORMS list since it is moved to Archive section. 

    That's it, your form is archived now.

     

    Please let me know if this works for you.

    Best regards.

  • Profile Image

    Answered by purpledragonhq on March 01, 2016 at 03:55 PM

    Thank you, but I don't need to archieve the form, but prior submissions. We are currently using the form, and want to archieve submissions to the form from 2013

  • Profile Image
    JotForm Support

    Answered by jonathan on March 01, 2016 at 05:46 PM

    There is no option in the Form Builder to 'archive' the submission data. 

    BUT what you can do instead is to load only the data you wanted within the date range you like.

    Here is the guide:

    1. While on the form's submissions page, click on Preferences icon (small gear image on the screenshot below) on the right side and select a date range. 

    2. Click the Time Frame drop down to show the list of options for partial downloading of submissions.

     

    You can also use "Custom Time Frame" to limit the date range of your submissions so you can get a smaller batch of submissions for easier download.

     

    When set, everytime you view the form's submission data, it will only show/load the data within the time range you have set.

    Hope this help. Let us know how we can asssist you further.

     

     

  • Profile Image

    Answered by stevedellar on October 12, 2016 at 10:32 AM

    I need to integrate the last 6 months is that possible that would be best for me?

     

    I do this in sheets by =QUERY(Submissions!A1:BL,"Select * ORDER by A DESC LIMIT 600 ",1)

    but by data will soon exceed google limits

  • Profile Image
    JotForm Support

    Answered by Jan on October 12, 2016 at 03:34 PM

    Once you filtered the submissions using the custom time frame as instructed by my colleague Jonathan, you can download the submissions as an Excel or CSV files.

    Related guide: How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    You can actually import an Excel file or CSV file in Google Spreadsheet, please check this guide from Google: https://support.google.com/docs/answer/40608?hl=en.

    Hope that helps. Thank you.

  • Profile Image

    Answered by stevedellar on October 13, 2016 at 06:13 AM

    this does not help we use google sheets to manage live data.  importing static data will not work for us

  • Profile Image
    JotForm Support

    Answered by Charlie on October 13, 2016 at 09:17 AM

    @stevedellar

    I have opened a separate thread for your concern, it would be best to discuss your concern on a thread specified for you. Please refer to this link instead: https://www.jotform.com/answers/959521. I will address it accordingly.

    Thank you.