How to Filter Entries in Jotform Tables

April 4, 2024

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
Youtube Embed Poster: XBgiESMQAo4

Filtering Entries by Submission Date

If you need to view submissions on your form sent on specific dates, you can filter them by Submission Date:

  1. In Jotform Tables, select Filter next to the search bar in the upper-left corner.
  2. In the search dialog, select 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 choose custom dates using the calendar.

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

Filtering Entries by Date

Unlike the Submission Date filter, other date-related data in Tables don’t have filter presets. To filter custom date fields:

  1. In Jotform Tables, select Filter next to the search bar in the upper-left corner.
An arrow pointing to Jotform Tables' Filter button
  1. In the search dialog, under Advanced Filters, add your 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, select Add New Filter in the lower-left corner.
An arrow pointing to Add New Filter in Jotform Tables' Filter window
  1. Now, add your 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, select Apply Filters in the lower-right corner.

Filtering Entries by Value

To filter submissions based on an exact value or answer on the form:

  1. In Jotform Tables, select Filter next to the search bar in the upper-left corner.
An arrow pointing to Jotform Tables' Filter button
  1. In the search dialog, under Advanced Filters, select Choose a Field, then choose a field to filter.
An arrow pointing to the Choose a Field dropdown in Jotform Tables' Filter window
  1. Next, 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. To add additional filters, select Add New Filter in the lower-left corner of the search dialog.

  1. Finally, select Apply Filter in the bottom-right corner.
An arrow pointing to the Apply Filter button in Jotform Tables

Editing and Removing Filters

To edit your existing filters, select Filter next to the search bar in the upper-left corner. To remove filters, select the remove (x) icon next to the Filter button.

An arrow pointing to the "X" icon, to remove filters, in Jotform Tables
Academy Logo

Introduction to Data Management

Tables Navigation

Go to course :Tables Navigation
lesson-3 - image
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:

  • Nathan Fuller - Profile picture
  • Membership DSV - Profile picture
  • Zinny McTackett - Profile picture
  • wissem Boukhari - Profile picture
  • 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