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
Notesfield containsrelocation.
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 emptyandIs not emptyto 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 withlooks at the first value andEnds withat 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 adminof the workspace the app is in and haveFull accessto every app the automation uses. App permissions alone aren't enough.
Add a filter on a text field
To filter a text field:
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.Under
And if the following conditions are met, selectAdd filter.In the new row, select the field and choose the text field.
Select the option and choose how to compare (listed under Options for text fields).
Enter the text. Options with no value, like
Is empty, don't ask for one.Select
Save changes.
Options for text fields
For single-line text fields, you can choose from these options:
IsandIs notcheck whether the whole text matches the value.ContainsandDoes not containcheck whether the value appears anywhere in the text.Starts withandEnds withcheck the beginning or the end of the text.Is emptyandIs not emptycheck whether there's any content at all.Has changedchecks whether the text was edited in this update. It's only offered with the triggerWhen 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:
ContainsandDoes not containcheck whether the value appears in the field.Starts withandEnds withcheck the beginning or the end, for examplehttps://or@acme.com.Is emptyandIs not emptycheck whether any value is set.Has changedchecks whether the field was edited in this update.
For location fields, you can choose from these options:
ContainsandDoes not containcheck whether the value appears in the location.Is emptyandIs not emptycheck whether a location is set.Has changedchecks 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:
Set the trigger to
When a record is createdinLeads.Add the filter
WhereEmailDoes not contain@acme.com.Select
Add filterand addWhereCompanyIs not empty.Select
Add action→Add comment. The step appears asAdd a comment to the current record. Enter "New outside lead: " and insert theCompanyfield.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 selectSave 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
Isand nothing matches, check the spelling, including capital letters.Isis case-sensitive,Containsisn't.
Test, pause, edit, or delete a filter
To test a filter, change a test record so it matches the condition, then click
▷next toManual runat the top right of the editor (tooltipView all runs) to openRuns. In aManual run, no field has changed, soHas changeddoesn'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 selectRemove. SelectSave changes.
Learn more
FAQs
How do I check that an email field has a certain domain?
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?
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?
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?
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?
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 →
