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

    CSV Reporting Database: Can we purge by date?

    Asked by neoranking on June 14, 2016 at 05:12 AM

    Does the system allow a purge function, can we do it by date? The list getting longer and longer.

     

    Please let me know thanks.

    Page URL:
    http://www.ashtree.com.sg/site-secure/

    CSV reporting purge thanks and system Getting
  • Profile Image
    JotForm Support

    Answered by Chriistian on June 14, 2016 at 07:38 AM

    Are you referring on the download of the form's submission in CSV format? You can partially download the submission by date by filtering first the submission date.

    You can check this article for the detailed steps on how to download submission: How to Download Form Submissions as Excel/CSV/PDF.

  • Profile Image

    Answered by neoranking on June 14, 2016 at 08:35 AM

    I'm giving this to our client
    https://www.jotform.com/excel/60887935218064

    Upon going to the link there's no option for it. It goes straight to downloading the file.
    and also they want to purge the list by date. Is this possible?

  • Profile Image
    JotForm Support

    Answered by Chriistian on June 14, 2016 at 09:52 AM

    Hi,

    Before downloading the file, in the Submissions page, they should be able to click on the gear icon at the top-right portion. In the Time Frame dropdown, they should select Custom Time Frame to be able to specify the date range of download. Please see steps below.

  • Profile Image

    Answered by neoranking on June 14, 2016 at 10:12 AM

    Sorry but our client don't have access to our JotForm.com account. So they will not be able to see this page.

    I'm just providing them this URL to download excel file and see their form's database.
    https://www.jotform.com/csv/61654293550053

     

  • Profile Image
    JotForm Support

    Answered by BJoanna on June 14, 2016 at 12:16 PM

    Unfortunately if you provide them the link of you CSV report only way for your user to remove some of the data is to do it manually, once they download report.  

    Other way is to partially download the submission by date, like my colleague suggested and then to provide your users downloaded data.

    Inside of this guide you can find how to do it:

    https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF 

    Hope this will help. Let us know if you need further assistance. 

  • Profile Image

    Answered by neoranking on June 16, 2016 at 10:36 PM

    Hi, I know we can filter the datas by date but are we able to delete datas inside database according to submission date?

  • Profile Image
    JotForm Support

    Answered by Chriistian on June 16, 2016 at 10:47 PM

    Yes, it is possible to delete the data according to the submission date. Simply follow the same steps for filtering the data at a certain date, then click on the "Delete Submissions in Time Range" button to delete the data.

  • Profile Image

    Answered by neoranking on June 16, 2016 at 10:48 PM

    Thanks Chriistian.