The List conditional filtering feature allows you to filter the list for one or more users based on the defined conditions. It's available through Conditional Filters in the List settings sidebar.
Let's see how it works. First of all, from the dropdown at the top you should choose whether the user needs to meet any or all of the conditions that will be defined further.
You can add as many conditions as required, and they'll be joined with OR (match any is selected) or AND (match all is selected).
Now, lets the see how the Condition is configured. There are three fields in Condition Settings:
Here, you need to select a field from the specified Airtable base, for which the condition will be defined.
is – the Field needs to match the Value exactly
is not – the Field has any value apart from the Value
is one of –the Field is any of the Value(s) (multiple values can be added)
is none of – the Fields has any other value apart from the Value(s) (multiple values can be added)
is empty – the Field is empty
is not empty – the Field is simply not empty and has a certain value
By default, you'll have user's Email and Email-Domain options here. However, if you've connected an Airtable users table, all the fields from that table will also become available for your choice.
Let's consider a specific example to make it clear how this works and in which cases it can be applied.
Let's imagine you have a task list with such fields as Assignee, Description, and Status. The Assignee field contains the emails of the users to which the task is assigned.
To be able to view their tasks, the users need to log into the system and navigate to the page with the list. However, you want each user to see only his/her tasks, and that can be achieved with a single condition. In Condition Settings we are going to set the Field to Assignee and Action to Logged in User's Email. This way the logged in user will only see those entries of the list, where the Assignee field corresponds to his/her email address. The below GIF illustrates this.
That's it. This way, you can set a condition for any of the fields in your list and filter the list accordingly for your logged in users.