Skip to main content

Automation filters

Add filters to your automation so it only continues for records that meet your conditions. Combine rows and groups, and pick the right options for each field.

Written by Leo

Filters decide whether an automation continues after its trigger fires. Each filter is a condition on a field, such as Where Amount ≥ (greater than or equal) 1000, and the automation only goes on when the record meets it. It's meant to help you react to the records that matter and leave the rest alone.

An automation in Tasks with two filter rows under And if the following conditions are met: Where Due date Is before Current date + 3 Days, And Status Is not Done. The action adds the comment Due soon: @Task / Title to the current record.

You can use filters for many things, including:

  • Sending a reminder only for invoices over 1,000 EUR.

  • Creating a follow-up task only when a lead's source is Website.

Note:

  • A filter stops the whole automation, not one action. If the record doesn't meet the conditions, none of the actions run, and Tape doesn't record a run. To skip only some actions, use Conditional actions (if and else) →.

  • Check what the value contains. If a filter's value comes from a field and that field is empty on a record, the condition can match every record. Learn more in My filter doesn't match →.

Add a filter

Filters sit under the trigger, in the block And if the following conditions are met. To add one:

  1. Open the database app on desktop or web and click the automations icon in the top bar (tooltip Create and view automations).

  2. Open an automation or create a new one.

  3. Under the trigger, select Add filter. If the block And if the following conditions are met is still empty, select Add filter in it again. The new row starts with a field and an option already chosen, for example Where Expense Contains Value.

  4. In the new row, select the field and choose the one to check.

  5. Select the option, then choose how to compare. The options depend on the field type.

  6. Enter or choose the value. Options such as Is empty don't need one.

  7. Select Save changes.

Add filter adds a row. Status is selected as the field, Has changed to as the option, and Approved as the value.

To copy or delete a row or a group, click ••• at the end of it, then select Duplicate or Remove. To turn off all filters at once without deleting them, hover over the filter block, click ••• to the right of it, and turn on Deactivate under Settings.

A filter row with Where, the field Status, the option Has changed to, and the value Submitted

A filter with no conditions always lets the automation run.

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

Combine conditions

Select Add filter again to add another row. Rows are joined with And by default, so every row has to be met. To make one row enough, select And in front of the second row and choose Or (At least one filter must match). The choice applies to all rows of that list.

For rules with several parts, select Add filter group. A group is a set of rows that you combine on their own, and it counts as one condition in the filter around it. A new group starts with And, so all of its rows have to be met. To switch the group to Or, select the word in front of its second row and choose Or. With Or, one matching row is enough.

For example, to continue for expenses of 1,000 or more, but only when they're submitted or have no approver yet:

  1. Add the filter Where Amount ≥ 1000.

  2. Select Add filter group.

  3. In the group, select Add filter and set Where Status Is Submitted.

  4. In the group, select Add filter again and set Approver Is empty.

  5. Select And in front of the second row of the group and choose Or.

In a new automation for Expenses with the filter Where Amount ≥ 1000, selecting Add filter group, adding Where Status Is Submitted and Approver Is empty to the group, then changing And in front of the second row of the group to Or

Filter options by field type

Each field type has its own options. Go to the page for the type you want to check:

When a filter searches for records, some options aren't available, such as Starts with, Ends with, and Has changed.

For a rule the options don't cover, open the settings of a row and select Turn into script filter to write the condition in JavaScript. Select Turn into classic filter to go back.

Filter, Conditional actions, or Filter collected?

Tape uses the same conditions in three places. Pick the one that fits what you want to stop:

  • The filter under the trigger decides whether the whole automation continues. Use them when a record shouldn't start any of the actions.

  • Conditional actions run the actions inside the block only when the condition is met, and the automation continues afterwards. Use them to treat records differently inside one automation. Learn more →

  • Filter collected narrows a list of records you gathered earlier, so the next actions only work on the records that match. Use it after a search. Learn more →

The Filter collected records action with the condition Where Amount greater than 5000

The same conditions are also used when you search for records, and in the break and continue conditions of loops.

Let's look at an example

Let's say a sales team wants to hear about big leads that aren't assigned yet. Here's how:

  1. Set the trigger to When a record is created in Leads.

  2. Under And if the following conditions are met, select Add filter and add Where Deal value ≥ 1000.

  3. Select Add filter group, add Priority Is Urgent and Owner Is empty to the group, then select And in front of its second row and choose Or.

  4. Select Add action → Add comment. The step appears as Add a comment to the current record. Enter "Big lead to assign: " and insert the Company field.

  5. Select Create automation.

The next time a lead of 1,000 or more comes in without an owner, you should see the comment on the lead!

Filter errors

  • If a filter row is incomplete, or uses a field that no longer exists, the editor marks it in red and the status below the automation's name shows Broken. Complete or remove the row, then select Save changes.

  • If a filter doesn't match when you expect it to, check the value first. A value that is empty at run time can match every record. See My filter doesn't match →.

  • Glob pattern for files isn't available when a filter searches for records. Learn more →

Learn more

FAQs

What's the difference between a filter and Conditional actions?

A filter under the trigger stops the whole automation when the record doesn't match. Conditional actions only wrap some of the actions, so the rest of the automation still runs.

Can I check the text of a comment or the date of a schedule?

Yes! With the trigger When a comment is added, add a filter on the comment Body, for example Contains urgent. With On a scheduled time or interval, you can filter on Current trigger date & time or Next trigger date & time.

Can I use a script for a rule the options don't cover?

Yes! Open the settings of a filter row and select Turn into script filter to write the condition in JavaScript. You can also use Execute script to calculate a value, then check it in Conditional actions. Learn more →

Why does my filter let every record through?

If a value is empty, or if the filter has no conditions, every record passes. Check the value and the trigger. Learn more →

Is a filter case-sensitive?

Is and Is not are case-sensitive. Contains, Does not contain, Starts with, and Ends with aren't. Spaces at the start and end are ignored.

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?