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 mobile filtering
One of the most useful functions of Airtable views is the ability to filter records by particular criteria. This enables you to more quickly find the records you need.
Here is a quick video showcasing how to set up a filter (on an iOS device):
iOS filtering flow
We'll now walk you through the full 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 filter
Next up, we will click on the "Filter" option in the upper right-hand corner to bring up the filtering options window.
Then, choose "Add filter" or the "+" sign 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 and appearing so that only records with a "High" or "Very high" priority are showing. When creating your own views remember that you can combine filters, group records, and hide fields to add further layers of customization to your views.