Case Limit Reached Rollup for Email

Share

Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.

Problem

Salesforce does not have a way of notifying anyone when the number of cases in the current month reaches a predefined limit for an account. 

Solution

  1. Create a target field on Account called Number of Cases This Month.
  2. Create a source number formula field on Case called Case Count.
  3. Create a rollup with a filter that has the CREATED DATE Equals THIS MONTH criterion and add it to the rollup.
  4. Create a workflow rule on the Account page that evaluates the rolled up value against the threshold to determine if the email should be sent out. 
Display/Update Opportunity Amount from Products, Quotes, or Other Custom Objects Rollup Helper Use Case Library Total Number of Live Chat Transcripts and Cases Worked
Chat Offline
Contact Us Here