I have used Newsletter agents before, with good success, based on the value of a specific field (open/close) and all documents assigned to one person. The person would get an email with all doc links to documents that needed their attention.
Not sure how I can do something somewhat similar, but I need to send an email to users when they have "not" submitted a document (report). So, there is a view with all documents, that are also categorized based on region. Is there a way to use UserRoles to be able to identify that their name is not in a specific week? So, let's say East has 3 people, and West has 5, the view would look like this:
And, lets say for a given week, or weeks, Person 2 did not submit a document and he belongs East and Person 6 (from West) is also missing documents from 3 weekly periods. How can I send an auto alert, on a weekly basis that might identify the weeks where users did not have a document posted? Is this even possible?