Are these three triggering records going to be new each day (i.e. they’re specific new tasks that you want to send reminders about), or are these records about the teammates (i.e. one record per teammate) and you want those same records to trigger a reminder email to each teammate every day?
If it’s the latter, here’s another way to approach it. Instead of using the “At a scheduled time” trigger, use the “When record matches conditions” trigger. The condition would be driven by a formula field that would output a 1 at a certain time of day. Because the formula would run on each record, it would trigger the automation once for each record and each teammate would receive a separate email.
As for the formula, it could look something like this if you wanted to trigger the email to send at 9 am every day:
HOUR(NOW() >= 9)
That would output a 1 when the current time reaches 9 am, and a 0 at all other hours before that. That way it would only trigger once per day, and the output switching to 0 at midnight would reset the trigger for the next day.
The only tweak that you’d need to make to this would be to change “9” based on your local timezone. The NOW() function is based on GMT, so the formula above would trigger at 9 am GMT. If your timezone is GMT +2 for example, then 9 am for you is 7 am GMT, so you’d use this formula:
HOUR(NOW() >= 7)
The only other thing to be aware of is that the NOW() function doesn’t update constantly. Per the documentation, it updates roughly every 15 minutes if your base is open, and roughly every hour when it’s closed. To account for this flexibility, you might consider picking a trigger time that’s a little earlier than you actually need it.
