Jotform Tables makes it easier to manage form data. Different filters can help you locate specific submissions based on date, answer selection, and unique information.
Let’s start with the date filter. Clicking the All Time button in the top toolbar provides you with a predefined list of date filters.
After selecting an option, close the window by clicking outside the popup to save the filter and display the results. Here’s an example when I choose Today.
The filter populates the filter bar on the left side and looks like this:
If you choose Custom dates, you can select the date range. To do this, first click the start date and then the end date. Here’s an example:
This specific date range creates the following filter:
To filter submissions based on an answer selection, click the Filter button and set your filter. For example, you can filter for submissions with an answer of “Yes” to the question, “Is this your first time reaching out to us?” This is a single-choice field, but you can use the same method for a dropdown field.
Click the Apply Filter button to display the submissions with “Yes” answer selections.
It’s currently not possible to filter answers to multiple-choice questions. This means you can only filter one answer selection at a time, and that selection will be displayed whether or not there are other selections in that field. Here’s an example where I filtered for “Facebook”.
If each of your forms has a unique reference number, you can filter for it using either equals or includes:
You can also filter elements that are text boxes or text areas. This applies to name, email, short text, and long text elements. For example, here’s a filter in the long text field for answers that include “amet.”
Click the Apply Filter button, and that’s it!
If you have questions or suggestions, feel free to reach out to us through one of our support channels below.
Send Comment:
10 Comments:
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