Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Conditions exactly match

Topic Labels: Automations
340 1
cancel
Showing results for 
Search instead for 
Did you mean: 

how can i match ‘exactly word’ in Automation trigger condition using contains?

look at the image below

Example

1 Reply 1

Welcome to the community, @Andrea! :grinning_face_with_big_eyes: If the word that you’re looking to match is always going to be surrounded by other words, you can put a space on either side of the word; e.g. " new " vs “new”.

A more reliable option is to use a formula to assist with the automation trigger. Formulas can handle much more complex logic than the condition options for automation triggers, and the newly-added regular expression functions are great for this. In this case, make a formula field using the following:

REGEX_MATCH(Title, "\\bnew\\b")

That will output a 1 for any title that contains the word “new” on its own (i.e. not part of any other word like “newness” or “sinew”). However, because this match is case sensitive it will only match “new”, but not “New” or “NEW”. To pick up any upper-/lowercase combination, use this:

REGEX_MATCH(Title, "\\b[Nn][Ee][Ww]\\b")

Then change your first automation condition to “When [formula field] = 1”.