Skip to main content

Filter automations by category and status

Let an automation continue only when a category, status, or task list has the option you need. See Is, Has any of, Has changed to, and more with an example.

Written by Leo

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 Interview or Offer stage.

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 to for one-time reactions. Is matches again with every later edit.

An automation in Leads with the trigger When a record is updated and Stage has changed, the filters Where Stage Has changed to Qualified and And Interests Has any of Solar and Storage, and the action Add a comment to the current record with Qualified lead: and the Company field

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 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 category or status field

To filter a category, status, or task list 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 category and status fields).

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

  6. Select Save changes.

In a new automation for Leads, selecting Add filter, choosing the Stage field, the option Has changed to, and the value Qualified

Options for category and status fields

For single category fields, you can choose from these options:

  • Is and Is not check the current category.

  • Is any of and Is none of check the current category against several options.

  • Is empty and Is not empty check whether a category is set.

  • Has changed and Has changed to check whether the category changed in this update, and to which option. They only appear when the trigger is When a record is updated. Learn more →

For status fields, you can choose from the same options, plus these:

  • Is completed and Is incomplete check whether the current status counts as done.

Opening the options of a Status filter row: Has changed, Has changed to, Is, Is not, Is any of, Is none of, Is completed, Is incomplete, Is empty, and Is not empty

For multiple category fields, where a record can have several categories, you can choose from these options:

  • Has any of is met when at least one of the chosen options is set.

  • Has all of is met when every chosen option is set, and others may be set as well.

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

  • Has none of is met when none of the chosen options is set.

  • Is empty and Is not empty check whether any option is set.

  • Has changed and Has changed to any of check 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: Contains and Does not contain check the item names. Is empty and Is not empty check whether the task list has items.

  • Status: Is completed is met when every item is ticked, Is incomplete when at least one item is still open.

  • Assignee: Is, Is not, Is any of, Is none of, Contains, Does not contain, Is empty, and Is not empty.

  • Due date: Is, Is not, Is before, Is after, Is empty, and Is not empty. With Is, 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:

  1. Set the trigger to When a record is updated and Stage has changed in Leads.

  2. Add the filter Where Stage Has changed to Qualified.

  3. Select Add filter and add Where Interests Has any of Solar and Storage.

  4. Select Add action → Add a comment to the current record, then enter "Qualified lead: " and insert the Company field.

  5. 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 select Save changes.

  • If Has changed to never matches in a test, make sure you changed a record. A Manual run doesn'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 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

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?

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?

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?

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?

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?