+5Hi Airtable Fans,
I am a fan of Airtable Automation but can’t find out something.
This is my automation goal:
When create a record
IF New Record match X condition (X could be “contain text …” in cell)
Then send an email
I don’t find how to put condition before sending an email.
And if I start automation with condition
+31Hmm, what’re you trying to achieve with the “New Record” condition? Is it just to ensure that the automation only runs once per record?
+5Exactly. I want that email is sent if and only if a new record match a certain condition (containing a special word).
+7Could 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?
+31Exactly. 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:
And its actions would be to send the email, and also an Update Record action to mark the checkbox
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.