Jotform Tables lets you easily analyze and manage your form data with its filter feature. It 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.
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:
- In Jotform Tables, open Filter next to the search bar in the upper-left corner.
- In the window that opens, click on All Time. You can choose your desired range in the date picker. You can either use the presets on the right or choose custom dates using the calendar.
- Click anywhere outside the Date Filter window, then select Apply Filter.
Filtering Entries by Search In
You can filter your form submissions by different categories, including whether they are Unread, Read, Starred, or Unstarred. To filter using Search In.
- In Jotform Tables, open Filter next to the search bar in the upper-left corner.
- In the window that opens, click on Search In to open the dropdown menu, then select your preferred option and click on Apply Filter.
You can select on your desired Search in based on your preferred filter. The available options are:
- All Submissions — This option shows all the form submissions regardless of their status.
- Unread — This filter shows only the submissions that you have not read yet.
- Read — This filter shows the form submissions that you have already read.
- Starred —The Starred filter displays all submissions that you have marked with a star.
- Unstarred — The Unstarred filter will display only the submissions that do not have a star.
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.
- In Jotform Tables, open Filter next to the search bar in the upper-left corner.
- Under Advanced Filters, choose a date field and enter the start date:
{your date field}, greater than or equal to, {the start date}
- Select Add New Filter in the lower-left corner.
- Configure the same date field for the end date:
{your date field}, less than or equal to, {the end date}
- Ensure both filters are using the same date field, then click on Apply your Filter.
Filtering Entries by Value
To filter submissions by field value or answer on the form
- In Jotform Tables, open Filter next to the search bar in the upper-left corner..
- Under Advanced Filters, specify the field and value to search, then apply your filter.
Editing and Removing Filters
You can edit your existing filters by opening Filter. To remove filters, select the remove icon next to the Filter button.
Send Comment:
15 Comments:
238 days ago
Is it possible to use one search/filter term across all the tabs of table?
Example: We have one form for data set A and one form for data set B (both sets include a 'name' field). We'd like to view all the data for Name 1 without having to filter each tab to his name - we'd like to just type the name once and it filters for each tab.
More than a year ago
Is it possible to apply a filter like "last seven days OR unstarred". I can do them separately but I'd like to view submissions matching both criteria in the one table
More than a year ago
Is it possible to create repirts from a filtered table?
More than a year ago
is it possible to isolate a specific value in the case of a question that contains several questions in it with a multiple choice answer?
Example :
Question : Do you use chili powder ?
Table :
For pizza:
For sauces :
For Gratin :
Answers : for each one choose : always, sometimes or never
and the goal is to isolate those who use chili powder "in pizza" "always"
More than a year ago
Is it possible to Set a filter that archives submissions based on certain criteria? Thanks
More than a year ago
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.?
More than a year ago
no files at all for the past year and the form name is grayed out in the list -- what is that about?
More than a year ago
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.
More than a year ago
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.
More than a year ago
Can we create and save more than one filter per form?
More than a year ago
I've lost my all time tab on the toolbar how do I put it back in??
More than a year ago
We have lost our All Time tab on the toolbar for quick date access. How do I put it back in? Thank you
More than a year ago
Print pdfs problems
More than a year ago
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 .
More than a year ago
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