I want to send an email in response to changes in a table over a period of time, two use cases:
The body of the email should show what changed.
It seems like I want to use either a Workflow with a timer mechanism (but I can’t think of how) or a Report to periodically check for changes, each approach seems like it would need some auxilliary data storage to be able to meet the “diff” criteria to be shown.
Reports can only run at most once a day, I wish we could run these hourly.
If there were a field that updated on a timer, that would make this very easy.
I need some advice on how to implement this, or an example…
12 (or 24, or 8, or whatever) daily reports, each scheduled for a different hour of the day.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |