![Michael_Leidens Michael_Leidens](https://community.airtable.com/legacyfs/online/avatars/3X/a/f/af704357be38a6a26dc284b7677355aed468e1dd.jpeg)
- 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?
![Michael_Leidens Michael_Leidens](https://community.airtable.com/legacyfs/online/avatars/3X/a/f/af704357be38a6a26dc284b7677355aed468e1dd.jpeg)
- 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).
![Hairtable Hairtable](https://community.airtable.com/legacyfs/online/avatars/2X/9/9275884ec5a04273bee20c887972db9f0810c25b.png)
- 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
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)