Filter

Filter your lists based on criteria

By default, your lists show all the rows coming from your data source (your data source could be a sheet or a Relation). However, you can filter the rows that appear in your list. You can also enable in-app filtering so that users can change the filtering themselves.

Filtering from the layout

Filter allows us to exclude items from our lists based on different criteria. Users will not be able to see items that you filter out of a list. For example, in the app below we add a filter that shows only the employees where the Is Manager column contains 'Yes'.

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

The filter is created by checking certain criteria on a column in your sheet. In the above example, we have a list of employees. Some are managers, some are not. We have a column in our sheet that identifies Top Managers and then values in that column of Yes and No.

In Glide, we select that column as the Filter column and then choose the criteria by which we are filtering.

Filtering setup

We use the same sheet as a 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.

Filtering different Tabs sharing same list of items

You can use Filter with Inline Lists and List Relations

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'

Multiple filters

In-app filtering

You can also enable in-app filtering for your users so they can change the items that are displayed in the list. This is particularly useful for long lists of items. In the example below, we enable in-app filter based on the Size column which allows users to see only the drinks with certain sizes.

In-app filtering