This is core funtionality in other systems such as Quickbase. There are many use scenarios where being able to automatically email a report/batch of records is very important, and individual email notifications are not practical.
I think you should be able to do this with integration tool Integromat (a bit like Zapier but more powerful). The process (Integromat Scenario) would be something like:
Get users with a Search
For each user, search for their outstanding tasks
Use an Aggregator to go through the tasks and add them together in a format suitable to send
Send the user an email
This could all be set up to run at a specified time (flexibility here depends on your account level).
Here's where you can find out more about Integromat - it really is great with Knack and code free.
I have a strong need for this. My users have many tasks assigned to them I would like to send a reminder email about each morning. It's impractical to send them 20+ emails at once, but one email with 20 tasks in it is reasonable.
Hello,
This would be most excellent! We have a case where a user needs just a gentle reminder that records are waiting for approval… just one email weekly indicating that records are in need of attention (not one email per record). Thank you!