
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 21, 2022 06:04 AM
Hi 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
- “When record matches conditions”, then it triggers all rows that meet the condition, not only the new records.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 21, 2022 06:29 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 21, 2022 09:07 AM
Exactly. I want that email is sent if and only if a new record match a certain condition (containing a special word).

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 21, 2022 02:23 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 22, 2022 03:29 AM
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
