function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AlibabaAlibaba 

Workflow threshold from Rollup sends too many e-mails

Hi,
 
I want a e-mail to go to a customer when an Account rollup field (rolled up from Opportunity) reaches a certain threshold. However, I want the e-mail to go out only once per month.
 
I set up a workflow rule to trigger when the threshold is reached, however, it triggers every time the rollup is changed.
 
I figured I'd create another field (e.g. 'E-mail Sent' checkbox), and set it when the workflow is fired. However, I can't figure out how to reset the checkbox automatically on the first of the month (workflows only work when something is edited).
 
Anyone have any ideas? Work-arounds?
 
Thanks very much.
Rafi