- grassmediaAsked 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.
- JotForm Supportardy0689Answered 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