Skip to main content

Filter automations by text fields

Let an automation continue only when a text, email, phone, link, or location field has the content you need. Learn which options each field type offers.

Written by Leo

You can filter text fields to let an automation continue only when a text, email address, phone number, link, or location has the content you need. Text filters check what is in the field right now.

You can use text filters for many things, including:

  • Continuing only for leads whose email doesn't end in @acme.com (your own company).

  • Flagging candidates whose Notes field contains relocation.

A new automation in Leads: When a record is created, the filters Where Email Does not contain @acme.com and And Company Is not empty, and the action Add a comment to the current record with New outside lead: @Lead / Company

This page covers these field types: single-line text, multi-line text, email, phone, link, and location.

Note:

  • Compare against a value, or leave the field empty on purpose. Use Is empty and Is not empty to check for missing content. A comparison against an empty value can match every record.

  • Email, phone, and link fields can hold several values. The filter checks all values of the field together as one text. Starts with looks at the first value and Ends with at the last.

Who can use filters on text 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 app is in and have Full access to every app the automation uses. App permissions alone aren't enough.

Add a filter on a text field

To filter a text field:

  1. Open the database app on desktop or web, click the automations icon in the top bar (tooltip 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 text field.

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

  5. Enter the text. Options with no value, like Is empty, don't ask for one.

  6. Select Save changes.

In a new automation for Leads, selecting Add filter, choosing the Email field and the option Does not contain, and entering @acme.com

Options for text fields

For single-line text fields, you can choose from these options:

  • Is and Is not check whether the whole text matches the value.

  • Contains and Does not contain check whether the value appears anywhere in the text.

  • Starts with and Ends with check the beginning or the end of the text.

  • Is empty and Is not empty check whether there's any content at all.

  • Has changed checks whether the text was edited in this update. It's only offered with the trigger When a record is updated. Learn more →

Multi-line text fields offer the same options as single-line text fields. The filter checks the complete text, without formatting.

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

For email, phone, and link fields, you can choose from these options:

  • Contains and Does not contain check whether the value appears in the field.

  • Starts with and Ends with check the beginning or the end, for example https:// or @acme.com.

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

  • Has changed checks whether the field was edited in this update.

A filter row on the email field Work email in a new automation for Employees, with the options open: Contains, Does not contain, Starts with, Ends with, Is empty, and Is not empty

For location fields, you can choose from these options:

  • Contains and Does not contain check whether the value appears in the location.

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

  • Has changed checks whether the location was edited in this update.

Let's look at an example

Let's say you only want to hear about leads from outside your own company. Here's how:

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

  2. Add the filter Where Email Does not contain @acme.com.

  3. Select Add filter and add Where Company Is not empty.

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

  5. Select Create automation.

The next time someone adds a lead with a different email domain, you should see the comment on the lead!

Text 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 matches more records than you expect, check whether the value is empty. A value that is empty at run time can match every record. See My filter doesn't match →.

  • If you're using Is and nothing matches, check the spelling, including capital letters. Is is case-sensitive, Contains isn't.

Test, pause, edit, or delete a filter

  • To test a filter, change a test record so it matches the condition, then click ▷ next to Manual run at the top right of the editor (tooltip View all runs) to open Runs. In a Manual run, no field has changed, so Has changed doesn't 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, click ••• at the end of the row or group, then select Remove. Select Save changes.

Learn more

FAQs

How do I check that an email field has a certain domain?

Use Ends with and enter the domain, for example @acme.com. Contains works too, but it also matches the domain anywhere else in the address.

Are text filters 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.

How do I check that a field is filled in?

Use Is not empty. It doesn't need a value.

Can I filter a location by city?

Yes, with Contains. Enter the city name. The filter checks the full text of the location, so it matches when the city is part of it.

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?