Skip to main content

Filter automations by people and relations

Let an automation continue only for certain people or linked records, including who created or last edited a record. See every option and an example.

Written by Leo

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 changed isn't available for it.

Automation editor with the trigger When a record is updated and any field has changed in Tasks, the filters Where Assignee Is empty and Last edited by Is not Juliet Adams, and the action Add a comment to the current record with the text Still without an owner and the Title field

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 admin of the workspace the database app is in and have Full access to 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:

  1. Open the database app and click the automations icon at the top right (Create and view automations), then open an automation.

  2. Under And if the following conditions are met, select Add filter.

  3. In the new row, select the field and choose the one you need.

  4. Select the option and choose how to compare (listed under Options for people and relation fields).

  5. Choose one or more people or records as the value. Options such as Is empty don't ask for one.

  6. Select Save changes.

Selecting Add filter, choosing the Assignee field, opening the option list, and choosing Is empty

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:

  • Is and Is not check the current person or record.

  • Is any of and Is none of check against several people or records.

  • Contains and Does not contain check whether the person's name or the record title includes the text you enter.

  • Is empty and Is not empty check whether anyone or anything is set.

  • Has changed and Has changed to check whether the value changed in this update, and to whom or what. They only appear when the trigger is When 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 of is met when at least one of the chosen people or records is set.

  • Has all of is met when all of them are set, and others may be set as well.

  • Is exactly is met when the chosen ones are the only ones set.

  • Has none of is met when none of them is set.

  • Contains and Does not contain check whether a name or record title includes the text you enter.

  • Is empty and Is not empty check whether the field has any value.

  • Has changed and Has changed to any of check whether the field changed in this update, and whether the new set includes any of the chosen ones.

The list of options of the multiple people field Assignee: Has changed, Has changed to any of, Has any of, Has all of, Is exactly, Has none of, Contains, Does not contain, Is empty, Is not empty

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:

  1. Set the trigger to When a record is updated and Any field has changed in Tasks.

  2. Add the filter Where Assignee Is empty.

  3. Select Add filter and add Where Last edited by Is not and choose the team lead.

  4. Select Add action → Add a comment to the current record, then enter "Still without an owner: " and insert the Title field.

  5. 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 by shows 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 as Author, 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 open Runs. A Manual run doesn't change the record, so Has changed options 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?

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?

Use Is empty on the assignee field. It doesn't need a value.

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?

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?

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?

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 →

Did this answer your question?