Hello,
I’m trying to make an automation to send several records to my suppliers at a scheduled time but I cannot make my automation works.
In my base, I have one table where I have hundreds of suppliers, and i’m using another table to register all the payments I make each day.
I would like an automation to :
- Search all the payments made the day before
- Make a list for each supplier
- Send only one mail per supplier with all the records matching the condition {Date of payment} is yesterday
The problem I have is that if I used as a trigger a specific time, i’m not able to make a list of each record by supplier. Either i have to send all the payments to all my supplier in one email, either I can select the records matching a supplier but the automation send one email per record so some of my suppliers will receive several times the same email.
I have hundreds of suppliers and payment each day so making one automation per supplier is not an option.
Anyone who can help me to fix it ?
Thank you !
Nicolas