Automated email reminders

[samadam]

I am trying to send automated emails to approvers of requests. Right now I have a job to trigger the emails but if they have multiple records to approve they will end up with a bunch of emails. Instead is it possible to trigger one email per approver? I have the approver captured in a field value so I can use that. Would a group by work?

[Kristen Ankeny]

If you just want to send one to each approver, then you could leverage glideAggregate against the "approver" column to get the unique entries and then trigger for each unique value found.