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

    Selective report generation or How to Filter Reports?

    Asked by grassmedia on February 03, 2014 at 02:50 AM

    I've found the report function to be incredibly useful for displaying form results back onto a web-page using either embedded RSS, Grid or table options but in doing this there appears to be no way to be slective about what's displayed - for example, show only submissions in the last day or show submissions where fieldx="xxx" kind of thing and I wondered if there was a way to do this natelivy or via a widget or plugin?  I could resort to "Form to MySQL" and then sort and filter the data for display in a database but just wondered if there was an easier, more streamlined way?

     

    Thanks in advance.

    Submissions table displaying form thanks
  • Profile Image
    JotForm Support

    Answered by ardy0689 on February 03, 2014 at 05:17 AM

    Thank you for contacting us in this forum. Unfortunately, our reports feature can only sort the submission data in ascending or descending order. Filtering from reports are not yet possible.

    There are 2 ways that is possible filter results.

    1. Downloading/Exporting to Excel. You need to go to the Form's Submission Page and export your submissions to Excel or CSV. Then do the Filtering on the Excel Spreadsheet

     

    To be able to show it on your website, you may also integrate your form using our Google Spreadsheet Integration and filter the results there. You may follow this guide to further embed the generated Google Spreadsheet to your website Embed a spreadsheet in a blog or webpage. However, past submission data will not be included. Only new submissions prior to the Integration will be on the Spreadsheet.

    2. You may also use our JotForm API-Get Form Submissions. This will require some programming knowledge to fetch submissions directly from JotForm servers. You can manipulate the data this way and show it directly on your website. This is similar to what you have in mind by using a database "Form to MySQL" but a direct a approach.

    I hope this information is useful to you. Please let us know if you need further assistance. Thanks