By default, your Collections show all the rows coming from your data source (which could be a table or a Relation). However, you can filter the rows that appear in your app's interface. You can also enable in-app filtering so that users can change the filtering themselves.
Filters are not a security feature.
Please note that filtering is not a security feature. If you use it, the app can still download filtered data. If your app has private or sensitive data then you should use Row Owners.
Filtering from the layout
Filter allows you to exclude items from your Collections based on different criteria. Users will not be able to see items that you filter out of a collection. For example, the app below contains a filter that shows only the employees where the Is Manager column contains Yes.
The filter is created by checking certain criteria on a column in your sheet. The above example has a list of employees. Some are managers, some are not. The sheet contains a column that identifies Top Managers and contains values in that column of Yes and No.
In Glide, select that column as the Filter column and then choose the criteria to filter by.
You can use the same sheet as a data source in multiple tabs and then filter each one in different ways. For example, the app below shows the same staff list in three different tabs. Each tab has the same exact source sheet, but each one is filtered to show only those with a different diet.
Multiple filters
We can use multiple filters on a list with AND + OR logic. In the following example, we add two filters to our list of cookies to show only items that include coconut or coffee in the Name column.
Name includes coconut
OR
Name includes coffee
In-app filtering
You can also enable in-app filtering for your users so they can change the items that are displayed in the collection. This is particularly useful for collections with a large amount of of items. The example below shows the configuration of an in-app filter based on the Size column, which allows users to see only the drinks with certain sizes.
Multiple in-app filters
If you’d like users to filter your Collections by more than one field, you can include multiple in-app filters. When multiple filters are added, the filtered results are displayed using AND logic. You can add as many in-app filters as you like by clicking the +Add filter button. For example, the inventory list below is filtered to include items from the Body category with Low Stock levels.
