function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DJP1SDJP1S 

Email Any Add or Change Except Two Fields

Hey everyone,

 

I'm trying to get a validation rule that emails the user whenever a record is created or edited, unless it happens to be on either of two fields. I'm still occasionally getting emails when I'm sure these fields are the only thing getting updated. I've selected "Run this rule if the following formula evaluates to true"

 

I want all fields to cause an email to be sent except when Most_Recent_Email__c or Most_Recent_Good_Lead__c are updated.

 

AND(
PRIORVALUE(Most_Recent_Email__c) = Most_Recent_Email__c,
PRIORVALUE(Most_Recent_Good_Lead__c) =Most_Recent_Good_Lead__c
)

David BermanDavid Berman
NOT(OR(
ISCHANGED(Most_Recent_Email__c),
ISCHANGED(Most_Recent_Good_Lead__c)
))