Validation Rule can be used to avoid update to Case record when the Status is Working. Validation Rule Formula:AND(ISPICKVAL( Status, 'Working' ),ISPICKVAL( PRIORVALUE( Status ), 'Working' ),NOT( ISNEW() ))Note:When the ....
Custom Permission can be checked in Validation Rule. Use $Permission.Custom_Permission_Name in the Validation Rule to check. If the User have Custom Permission via profile or permission set, then it will ....
Sample Validation Rule:AND(Is_Active__c,NOT( ISCHANGED( Is_Active__c ) ),NOT(ISNEW()))Output:
Sample Case Queue: Validation Rule: Output:
VALUE() method converts text to a number. So, we can easily use it to check whether Text field value is less than or equal to zero. Check the below example.
Validation Rule: AND( IF( IsNew(), true, IF( PRIORVALUE( IsClosed ), ISCHANGED( CloseDate ) , false ) ), MONTH( CloseDate ) != MONTH( TODAY() ), IsClosed )
1. Create a custom field on the Account. 2. Create a Workflow Rule on the Opportunity Object. 3. Create a Field Update on Opportunity Object. 4. Create a Validation Rule ....
Syntax: OR( NOT( REGEX( Emails__c , "([a-zA-Z0-9._-][email protected][a-zA-Z]+.[a-zA-Z,]{2,4})*") ), RIGHT( Emails__c , 1 ) = "," )
\s is used in Validation rule for blank space or white space in Salesforce. Sample Validation Rule: AND( NOT(ISBLANK(Test__c)), AND(NOT(REGEX(Test__c, '\d{14}')), NOT(REGEX(Test__c, '\d{3}\s{1}\d{3}\s{1}\d{3}\s{1}\d{5}')) ) ) This will support only the below ....
Use NOT(ISNEW()) to fire validation rule only in update operation in Salesforce. Sample Validation rule: AND( NOT(ISNEW()), ISCHANGED( City__c ), ISCHANGED( State__c ) ) Cheers!!!
