How to Filter Entries in Jotform Tables

December 22, 2022

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 even save filtered entries into tabs.

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 then All time.
tables-filter-all-time-min.png
  1. Next, choose the range in the date picker.
tables-filter-date-preset-min.png

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

  1. Finally, click anywhere outside the date picker then click on Apply Filter.
tables-apply-date-filter-min.png

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.
tables-filter-date-of-birth-min.png
  1. In the Advanced Filters section, set the filter for the start date:
{your date field}, greater than or equal to, {the start date}
tables-filter-date-of-birth-start-min.png
  1. Next, click on Add New Filter just below to create a filter for the end date.
tables-filter-date-of-birth-add-min.png
  1. Now, set the filter for the end date:
{your date field}, less than or equal to, {the end date}
tables-filter-date-of-birth-end-min.png

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.
tables-contact-form-filter-min.png
  1. In the Advanced Filters section, click on Choose a Field then select the field to filter.
tables-contact-form-filter-choose-field-min.png
  1. In the Advanced Filters section still, choose or provide the value to filter in the third input field.
tables-contact-form-filter-email-min.png

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.
tables-contact-form-apply-email-filter-min.png

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.

tables-remove-filter-min.png
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: