Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 07, 2021 10:46 PM
how can i match ‘exactly word’ in Automation trigger condition using contains?
look at the image below
Apr 12, 2021 09:18 PM
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”.
May 25, 2023 09:35 AM
Hello, is there any way we can match exactly on automations? as formula is not available.