Creating a Report Based on selections Made in a Form

  • FWRC
    Asked on September 20, 2017 at 12:22 PM

    I've created an RSVP form that includes the option to attend multiple events.  https://form.jotform.us/72344732664156

    I need to be able to generate a report based on date selections and would like to do so without having to run a full spreadsheet and sorting and deleting. Any suggestions regarding how I could go about doing that? I thought perhaps cloning the form and then adding the spreadsheet to form widget might work as I could then run a spreadsheet from the original form and upload it to the form based on entries for a single event. Last step would be to create a report from the standard report feature for the event coordinator to use in planning. That doesn't seem to be an option either.

  • Ashwin JotForm Support
    Replied on September 20, 2017 at 1:12 PM

    I am not sure if I have understood your question correctly. Do you mean to say that you want to filter the submission and create report with the filter criteria?

    Unfortunately it is currently not possible to create report with filter condition. When you create a report, it will always display all the submissions records. 

    I would suggest you to please take a look at our "Visual Report" and see if that fits into your requirement. The following guide should help you:  https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions

    You will be able to filter submissions in visual report and the following guide should help you:  http://www.jotform.com/help/281-How-To-Use-Visual-Report-Filters

    You may also like to take a look at our "Submission View" app and see if it fits into your requirement.