You can filter category, status, and task list fields to let an automation continue only when a record has the option you need. Option filters are the most common way to react to a stage, a priority, or a progress step.
You can use these filters for many things, including:
Notifying the listing agent when a property's status changes to
Under contract.Continuing only for candidates in the
IntervieworOfferstage.
This page covers these field types: single category, multiple categories, status, and task list.
Note:
Pick the option from the list. You choose the category or status from the options of the field, not by typing its name.
Use
Has changed tofor one-time reactions.Ismatches again with every later edit.
Who can use filters on category and status 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 category or status field
To filter a category, status, or task list 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 category and status fields).
Choose one or more options as the value. Options such as
Is emptydon't ask for one.Select
Save changes.
Options for category and status fields
For single category fields, you can choose from these options:
IsandIs notcheck the current category.Is any ofandIs none ofcheck the current category against several options.Is emptyandIs not emptycheck whether a category is set.Has changedandHas changed tocheck whether the category changed in this update, and to which option. They only appear when the trigger isWhen a record is updated. Learn more →
For status fields, you can choose from the same options, plus these:
Is completedandIs incompletecheck whether the current status counts as done.
For multiple category fields, where a record can have several categories, you can choose from these options:
Has any ofis met when at least one of the chosen options is set.Has all ofis met when every chosen option is set, and others may be set as well.Is exactlyis met when the chosen options are the only ones set.Has none ofis met when none of the chosen options is set.Is emptyandIs not emptycheck whether any option is set.Has changedandHas changed to any ofcheck whether the categories changed in this update, and whether the new set includes any of the options.
For task list fields, first choose what to check:
The items:
ContainsandDoes not containcheck the item names.Is emptyandIs not emptycheck whether the task list has items.Status:Is completedis met when every item is ticked,Is incompletewhen at least one item is still open.Assignee:Is,Is not,Is any of,Is none of,Contains,Does not contain,Is empty, andIs not empty.Due date:Is,Is not,Is before,Is after,Is empty, andIs not empty. WithIs, one item with a matching due date is enough.
With When a record is updated, you can also check changes to a task list: Has changed, Item has been added, Item has been deleted, and Changed item contains for the items, and Item has changed to for the Status.
Let's look at an example
Let's say the sales team wants a note when a lead moves to a promising stage. Here's how:
Set the trigger to
When a record is updatedandStagehas changedinLeads.Add the filter
WhereStageHas changed toQualified.Select
Add filterand addWhereInterestsHas any ofSolarandStorage.Select
Add action→Add a comment to the current record, then enter "Qualified lead: " and insert theCompanyfield.Select
Create automation.
The next time someone moves an interested lead to Qualified, you should see the comment on the lead!
Category and status 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 a filter stops matching after you edited the database app, check whether the option still exists in the field. If an option was deleted, the automation is marked
Broken. Open the filter and choose an option that exists, then selectSave changes.If
Has changed tonever matches in a test, make sure you changed a record. AManual rundoesn't change one. See Filter automations by field changes →.
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
What's the difference between Is and Has changed to?
What's the difference between Is and Has changed to?
Is checks the current value, so it matches again with every later edit. Has changed to matches only in the update where the value changed to that option.
How do I check that a record has two categories at once?
How do I check that a record has two categories at once?
Use Has all of with both options. Is exactly would also require that no other category is set.
How do I find records that aren't done?
How do I find records that aren't done?
Use Is incomplete on a status field. It matches every status that doesn't count as done, so you don't have to list them.
Can I filter on the previous status?
Can I filter on the previous status?
Yes! With When a record is updated, select the field in the filter row and choose the status under the previous values of the record, for example Lead previous values. With other triggers, add Get previous values and compare the previous value with Is or Is not in Conditional actions. 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 →
