I am pretty new to using Airtable and have my first issue : I set an automation “when records matches conditions” → “Send Email”.
I have the right table and the right conditions.
What I would like to do : there is 4 records that are currently matching my condition (based on a due date to come in 45 days) but the email only sends the information on the first record and NOT the other 3.
How can I do to make sure that my email includes the other 3 records ? Or at least, that 3 other emails get sent If I can’t put together the info on my 4 records.
The idea would be to have a dynamic alert system when a record matches the due date to come in 45 days.
I hope this is clear enough