Help

schedule daily to see 1 or more records have yesterday's date and if so, send one email

Topic Labels: Automations
Solved
Jump to Solution
546 3
cancel
Showing results for 
Search instead for 
Did you mean: 
swtani
5 - Automation Enthusiast
5 - Automation Enthusiast

I teaching myself automations and have a requirement I cannot figure out how to get to work. Love ideas.

I need to set up a daily automation that looks at all of the records in a certain table and if any record has yesterday's date, send a single email to the recipient that includes a link to a view to look at the data. 

So the logic would be something like in table X, count number of records where payment date = yesterday. If count > 0, send an email with a link to a view that shows all the records with payment date = yesterday.

Thank you!!!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try creating a view that will show all the records where the payment date = yesterday, and have an automation that will trigger once a day to find all the records in that view and send them out as an email digest?

https://support.airtable.com/docs/how-to-create-email-digests-with-automations

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try creating a view that will show all the records where the payment date = yesterday, and have an automation that will trigger once a day to find all the records in that view and send them out as an email digest?

https://support.airtable.com/docs/how-to-create-email-digests-with-automations

swtani
5 - Automation Enthusiast
5 - Automation Enthusiast

We will only want to send the email when there are records that match the condition. So check daily but only send the email when there are records in the view. When I read through the above link and tried to set this up, it doesn't seem to have a way to do this.

swtani
5 - Automation Enthusiast
5 - Automation Enthusiast

I got it to work with the find record. Still learning. Thank you!