Help

Re: Conditions exactly match

1978 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrea
5 - Automation Enthusiast
5 - Automation Enthusiast

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

look at the image below

Example

2 Replies 2

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”.

Selimafifi
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, is there any way we can match exactly on automations? as formula is not available.