Welcome to the community, @Nicolas_Condouret!
Airtable’s Automations won’t loop through records, which is what you need it to do. You need it to loop through suppliers, and then send an email to each supplier with their payments from the day before.
So you would need to come up with a workaround to do this. A few common workarounds are:
-
Writing a custom Javascript script to loop through your suppliers.
-
Instead of looping through records, figure out a way to trigger each supplier individually, so they each trigger their own individual automation. You could write a formula field in Airtable that compares the current day & hour to NOW(), and if it’s the same, then it could result in the phrase “Send Email”. This phrase could be the trigger for your automation. (This one is relatively advanced to pull off, since Airtable doesn’t refresh NOW() on a reliable schedule.)
-
Instead of looping through records, you could create a utility table that links to your current suppliers table, along with 2 automations. This is a popular trick that I describe in this BuiltOnAir podcast episode:
- You can use an external no-code/low-code automation tool like Make, which gives you both (1) 100% accurate scheduling times, and (2) always loops through found records to send individual emails. Your Make scenario could search for the suppliers, and then Make will automatically loop through all the suppliers for you. For each supplier, you could then search for all of their payments from the day before. Then, you could aggregate all of those payments together using the text aggregator, and put the text into an outgoing email. Your Make scenario might look something like this:
