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
sfdc dev 2264sfdc dev 2264 

Long text area validation rule

Hi ,

     I have a validation rule which should fire only on a long text area change , but it fires if its not changed , Please help me on the validation rule condition that it should fire only if the description(Long text area) is changed.

Please find my validation rule condition :
  
VALIDATION RULE :

AND( 
$Setup.EnableValidationRule__c.VR_Description_field_is_locked_QCC__c = TRUE,
ISCHANGED(Description), 
OR( 
RecordType.DeveloperName = 'CCC_Baggage', RecordType.DeveloperName = 'CCC_Complaints', RecordType.DeveloperName = 'CCC_Compliment', RecordType.DeveloperName = 'CCC_Further_Action_Required', RecordType.DeveloperName = 'QCC_Insurance_Letter_Case', RecordType.DeveloperName = 'CCC_Medical', RecordType.DeveloperName = 'CCC_On_The_Spot_Recovery', RecordType.DeveloperName = 'CCC_Query' 
) 
)

Kindly help me pls

Thanks in Advance
Raj VakatiRaj Vakati
Your validation rule is correct .. can you check is there any other process that updates the description 
sfdc dev 2264sfdc dev 2264
I switched on the debug logs to check but i didnt find anyother process happening simultaneously
Raj VakatiRaj Vakati
try below one 
  
VALIDATION RULE :

AND( 
$Setup.EnableValidationRule__c.VR_Description_field_is_locked_QCC__c = TRUE,
ISCHANGED(Description), 
NOT(ISNEW()),
OR( 
RecordType.DeveloperName = 'CCC_Baggage', RecordType.DeveloperName = 'CCC_Complaints', RecordType.DeveloperName = 'CCC_Compliment', RecordType.DeveloperName = 'CCC_Further_Action_Required', RecordType.DeveloperName = 'QCC_Insurance_Letter_Case', RecordType.DeveloperName = 'CCC_Medical', RecordType.DeveloperName = 'CCC_On_The_Spot_Recovery', RecordType.DeveloperName = 'CCC_Query' 
) 
)