How to Filter Entries in Jotform Tables

Last Update: 

Jotform Tables makes it easier to manage your form data. Filters can help you search entries by dates, status, tags, terms, or answers. You can download, delete, or archive the filtered entries or save them into tabs.

An arrow pointing to the filtered entries' Create a New Tab button in Jotform Tables

Filtering Entries by Submission Date

If you need to view your form entries sent on specific dates, you can filter them by Submission Date. Here’s how:

  1. In Jotform Tables, click on Filter next to the search bar on the upper-left side, then choose All time.
The filter window in Jotform Tables with arrows pointing to the Filter button and All time dropdown
  1. Next, choose the range in the date picker.
Jotform Tables' date picker in the filter window

You can either use the presets on the right or select custom dates using the calendar.

  1. Finally, click anywhere outside the date picker, then click on Apply Filter.
A Submission Date filter in Jotform Tables with an arrow pointing to the Apply Filter button

Filtering Entries by Date

Unlike the previously discussed Submission Date filter, other date-related data in Tables doesn’t have presets to filter by periods. Here’s how to filter them using Advanced Filters:

  1. In Jotform Tables, click on Filter next to the search bar in the upper-left corner.
An arrow pointing to Jotform Tables' Filter button
  1. In the Advanced Filters section, set the filter for the start date:
{your date field}, greater than or equal to, {the start date}
A highlight on the Date of Birth start filter in Jotform Tables
  1. Next, click on Add New Filter just below to create a filter for the end date.
An arrow pointing to Add New Filter in Jotform Tables' Filter window
  1. Now, set the filter for the end date:
{your date field}, less than or equal to, {the end date}
A highlight on the Date of Birth end filter in Jotform Tables

Make sure that both filters have the same date field.

  1. Finally, click on Apply Filters in the lower-right corner of Advanced Filters.

Filtering Entries by Value

If you need to filter submissions based on an exact value or answer on the form, you can do so using Advanced Filters. Here’s how:

  1. In Jotform Tables, click on Filter next to the search bar in the upper-left corner.
An arrow pointing to Jotform Tables' Filter button
  1. In the Advanced Filters section, click on Choose a Field then select the field to filter.
An arrow pointing to the Choose a Field dropdown in Jotform Tables' Filter window
  1. In the Advanced Filters section still, choose or provide the value to filter in the third input field.
An arrow pointing to the term-to-search email filter in Jotform Tables

You can set the filter’s condition in the second input field. You can also add additional filters by clicking on Add New Filter in the lower-left corner of Advanced Filters.

  1. Finally, click on Apply Filter in the bottom-right corner of Advanced Filters.
An arrow pointing to the Apply Filter button in Jotform Tables

Editing and Removing Filters

You can click on the Filter button to edit existing filters. To remove filters, click on the remove (x) icon next to the Filter button.

An arrow pointing to the "X" icon, to remove filters, in Jotform Tables
Was this guide helpful?
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • Denise Harris - Profile picture
  • Jean Marc Bitaud - Profile picture
  • Susan Picatti - Profile picture
  • Alpenverein Wolfurt - Profile picture
  • cam.serv.engie - Profile picture
  • IPWA - Profile picture
  • Orri_Hallam_Street - Profile picture
  • mandymacfarlane1 - Profile picture
  • Anton fallah - Profile picture
  • Morganti Angelo - Profile picture
  • FabAcademy - Profile picture