Automatically generated filtering tools
Every table in your Jet app has built-in filtering functions. There are two ways to access these:
- 1.Click on the filter icon on the upper right of the table.
- 2.Click on the field you want to filter at the top of the table and choose Filter by field.
In both of these cases, it is necessary to choose the logical expression for filtering and then type in the value that you wish to use for the filter. If you want to create a filter that provides a list of values to choose from, add a filter component.
You can also use the same built-in filtering tools in the Data Editor. The process is the same, the only difference is that the filter button is on the upper left of the Data Editor instead of being on the upper right.
To filter a table using multiple values, go through the process as above, but choose the logical expression is one of. This will allow you to enter as many values as you want; once you've entered the desired values, click on your app, and the filter will be applied.
If you want to use multiple filters (filters that relate to different fields), you can also do that: after you've applied your first filter, click on Add filter at the top of the table, and apply a new filter.