Hmm, what’re you trying to achieve with the “New Record” condition? Is it just to ensure that the automation only runs once per record?
Exactly. I want that email is sent if and only if a new record match a certain condition (containing a special word).
Could you have a view filtered on « if field (in new record) contains “word” »
Then an automation triggered by “when record enters view” (above view name).
Would this combination work for you?
Exactly. I want that email is sent if and only if a new record match a certain condition (containing a special word).
Ah okay. If I were you I’d create a field to track whether an email was sent for that record or not instead, e.g. with a checkbox
The automation would then trigger based on conditions:
- match X condition (X could be “contain text …” in cell) like you wanted
- Checkbox is empty
And its actions would be to send the email, and also an Update Record
action to mark the checkbox