You can filter people and relation fields to let an automation continue only for certain people or linked records. This includes the system fields Created by and Last edited by, which tell you who made a record or changed it last.
You can use these filters for many things, including:
Continuing only when a task has no assignee yet.
Ignoring changes that one particular colleague made.
This page covers these field types: single person, multiple people, single relation, multiple relations, Created by, and Last edited by.
Note:
A relation filter checks which records are linked and their titles, not their other fields. To check another value of the linked record, get the related records first. Learn more →
Created by never changes.
Has changedisn't available for it.
Who can use filters on people and relation fields?
Automations are available on all plans: Free, Plus, and Premium. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.
To create, edit, pause, or delete automations, you need to be a
Workspace adminof the workspace the database app is in and haveFull accessto every database the automation uses. App permissions alone aren't enough.
Add a filter on a people or relation field
To filter a people or relation field:
Open the database app and click the automations icon at the top right (
Create and view automations), then open an automation.Under
And if the following conditions are met, selectAdd filter.In the new row, select the field and choose the one you need.
Select the option and choose how to compare (listed under Options for people and relation fields).
Choose one or more people or records as the value. Options such as
Is emptydon't ask for one.Select
Save changes.
Options for people and relation fields
For fields that hold one person or one record (single person, single relation, Last edited by), you can choose from these options:
IsandIs notcheck the current person or record.Is any ofandIs none ofcheck against several people or records.ContainsandDoes not containcheck whether the person's name or the record title includes the text you enter.Is emptyandIs not emptycheck whether anyone or anything is set.Has changedandHas changed tocheck whether the value changed in this update, and to whom or what. They only appear when the trigger isWhen a record is updated. Learn more →
Created by offers Is, Is not, Is any of, Is none of, Contains, Does not contain, Is empty, and Is not empty.
For fields that hold several people or records (multiple people, multiple relations), you can choose from these options:
Has any ofis met when at least one of the chosen people or records is set.Has all ofis met when all of them are set, and others may be set as well.Is exactlyis met when the chosen ones are the only ones set.Has none ofis met when none of them is set.ContainsandDoes not containcheck whether a name or record title includes the text you enter.Is emptyandIs not emptycheck whether the field has any value.Has changedandHas changed to any ofcheck whether the field changed in this update, and whether the new set includes any of the chosen ones.
Let's look at an example
Let's say the team lead wants to know when a task is still without an owner after someone else edited it. Here's how:
Set the trigger to
When a record is updatedandAny fieldhas changedinTasks.Add the filter
WhereAssigneeIs empty.Select
Add filterand addWhereLast edited byIs notand choose the team lead.Select
Add action→Add a comment to the current record, then enter "Still without an owner: " and insert theTitlefield.Select
Create automation.
The next time a colleague edits an unassigned task, you should see the comment on the task!
People and relation filter errors
If an automation can't be saved while you're setting it up, the editor marks the part of the filter row that's missing or invalid. Complete or remove the row, then select
Save changes.If you remove a person from your organization, check the filters that point to that person.
If a record in the filter no longer exists, the automation is marked
Broken. Open the filter and choose a record that exists.If
Last edited byshows an unexpected value, remember that changes made by automations count as edits too. By default, the automation counts as the editor. If an action has a person set asAuthor, that person counts instead. Learn more about action settings →
Test, pause, edit, or delete a filter
To test a filter, change a test record so it matches the condition, then select the runs button at the top of the automation (
View all runs) to openRuns. AManual rundoesn't change the record, soHas changedoptions may not match.To edit a filter, open the database app, click the automations icon in the top bar, then select the automation. Change the field, option, or value, then select
Save changes.To delete a filter, select the settings button at the end of the row or group, then select
Remove.
Learn more
FAQs
How do I run an automation only for records I created?
How do I run an automation only for records I created?
Use Created by Is and choose yourself. You can also choose a value from the record, such as Last edited by or a person field, instead of a fixed person.
How do I find tasks nobody is working on?
How do I find tasks nobody is working on?
Use Is empty on the assignee field. It doesn't need a value.
How do I check that two specific people are both assigned?
How do I check that two specific people are both assigned?
Use Has all of and choose both. Is exactly would also require that nobody else is assigned.
Can I filter on a value inside the linked record?
Can I filter on a value inside the linked record?
Not with a relation filter. Use Get related to bring the linked record in, then check its fields. Learn more →
Where can I find all automation filter options?
Where can I find all automation filter options?
In Automation filters →. It explains how to combine rows and groups and links to the options for each field type.
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: Filters in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
