Hi, I have followed How to create email digests with automations – Airtable Support
and all works fine except, how do I prevent the email going when no records are found i.e. the email should only go when the action in step 2 (Find records) has found records?
Solved
Email digest sent even when no records found
+5Best answer by PeterB
RJ @ Airtable gave me this, which works fine for me.
“there is a workaround in which you can insert a script action after the Find records step to achieve this – check out the video here to guide you through how to do it!”
+24Yah, I too am keen on hearing how to only send an email if there’s data to email.
+21Until Airtable adds branching and conditional behavior to automations, my preference is to split a process into two separate automations, with one calling the other via a webhook only when it needs to run. I shared some thoughts on this in another recent thread on this topic:
The downside is that it nearly doubles the number of automations run for that process, but it’s the best that can be done for now.
+5RJ @ Airtable gave me this, which works fine for me.
“there is a workaround in which you can insert a script action after the Find records step to achieve this – check out the video here to guide you through how to do it!”
+21While that technically works, it’s going to bug you with an error message—including an email—every time that the automation fails. Without checking that error message every single time, you won’t know if it’s a legit error that needs to be addressed or just a lack of found records. I also don’t like the idea of equating “no found records” with an error, because it’s not an error. I’d still prefer a solution that just ends cleanly, and the two-automation process that I outlined is the only way that I’m aware of to do that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.