Each table in Airtable can have any number of views. Views, as the name implies, allow you to "view" your records in different ways. For example, you may create a view that hides several columns and only shows task records that have been assigned to you. Whenever you hide or reorder columns, apply filters, or sort and reorder rows, those changes will only apply to your current view.
Introduction to filtering on mobile
NOTEWe are currently gradually rolling out new functionality and a new look for filtering records. The process for creating filters is essentially the same—so if your mobile interface doesn't quite match the screenshots below, don't worry; it soon will!
One of the most useful functions of Airtable views is the ability to filter through your records by particular criteria. This enables you to more quickly find the records you need. To create a new filtering condition, select the "Filter" option from the view menu, then configure your condition(s).
Here is a quick video showcasing how to set up a filter (on an Android device):
Creating a view with filtering conditions
We'll now walk you through the entire process. Let's say that we have a Sales CRM base where we are tracking the details of opportunities. We already have various views to use, but we would like to add another that will only show "High" and "Very high" priority opportunities. To do this, we will need to create a new view and filter that view.
Step 1: Create a new view
In the "Opportunities" table, we will click the view drop-down menu and then click "Create a view."
This will bring up the view creation window. For this example, we want to create a grid view that we will call "High priority opportunities." Once you have selected the appropriate view type and named the view click "Done" to create the view.
Step 2: Add the condition
Next up, we will click on the "Filter" option in the upper right-hand corner to bring up the window where we can add conditions.
Then, choose the "Add a condition" button to set up the view the way you want it. For our example, we need to add a filter that will show records where the "Priority" field "is any of "High" and "Very high."
At this point, our view is now filtered so that only records with a "High" or "Very high" priority are showing. When creating your own views, remember that you can use condition groups, group records, and hide fields to add further layers of customization to your views.