Filter

Filter your content based on criteria.

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.

Setting up a filter.

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.

Setting up the filter in Glide.

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.

Setting up the coconut or coffee filter.

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.

Setting up in app filtering.

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.

Multiple in-app filtering.

Have a question about Filter? Ask the Glide community.

Updated more than a week ago
Was this article helpful?