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:
- In Jotform Tables, click on Filter then All time.
- Next, choose the range in the date picker.
You can either use the preset on the right or select custom dates using the calendar.
- Finally, click anywhere outside the date picker then click on Apply Filter.
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:
- In Jotform Tables, click on Filter next to the search bar in the upper-left corner.
- In the Advanced Filters section, set the filter for the start date:
{your date field}, greater than or equal to, {the start date}
- Next, click on Add New Filter just below to create a filter for the end date.
- Now, set the filter for the end date:
{your date field}, less than or equal to, {the end date}
Make sure that both filters have the same date field.
- 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:
- In Jotform Tables, click on Filter next to the search bar in the upper-left corner.
- In the Advanced Filters section, click on Choose a Field then select the field to filter.
- In the Advanced Filters section still, choose or provide the value to filter in the third input field.
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.
- Finally, click on Apply Filter in the bottom-right corner of Advanced Filters.
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.
Send Comment:
11 Comments:
Is it possible to Set a filter that archives submissions based on certain criteria? Thanks
Bonjour
Est ce qu'il existe une option de partage de vue filtre par lien en lecture seule sans que le destinataire puisse enlever ce filtre.?
no files at all for the past year and the form name is grayed out in the list -- what is that about?
I would like to have more then one (>1) filter on a specific field. Currently the filter settings take each field (other than submission date) only once.
Additionally I cannot select a filter like "selectbox = empty |filled". It allows only to select a certain value.
Lo malo que cuando descargo los pdf desde la ventana tablas, los registros se agrupan , es decir si tengo 100 registros en una fechas, cuando me descargo el PDF me salen solo 6 pdf, y dentro hay varios registros. Yo no quiero eso, porque tendría que separar cada registro, y en algunos casos los registros no están en una sola hoja.
Por eso quisiera que la opciones de tabla me de la opción de descarga los PDF, por fecha pero si tengo 20 registros me descargue 20 PDF de cada registro.
Can we create and save more than one filter per form?
I've lost my all time tab on the toolbar how do I put it back in??
We have lost our All Time tab on the toolbar for quick date access. How do I put it back in? Thank you
Print pdfs problems
Buongiorno il campo ricerca non funziona per la colonna 2 Targa. Può essere perché trattasi di colonna collegata ad altro Tabella? E' possibile implementare una soluzione ? Grazie .
how can I organize the columns back the way they were before I filtered them?
I need them to follow the order of the form...but after I filtered some info, it does not go back!
thanks