Check the following formula for Validation Rule to support 10 digit number or Email Address. Validation Rule: NOT ( OR ( REGEX( InfallibleTech__Employee_Name__c , '[0-9]{10}'), REGEX ( InfallibleTech__Employee_Name__c , '[a-zA-Z0-9._-]+@[a-zA-Z]+.[a-zA-Z]{2,4}') ....
INCLUDES() is used to write a validation rule of Multiselect Picklist in Salesforce. Determines if any value selected in a multi-select picklist field equals a text literal you specify. Syntax: INCLUDES(multiselect_picklist_field, ....
A regular expression is a string used to describe a format of a string according to certain syntax rules. [ab] - A single character, either a or b [a-zA-Z] ....
Sample Validation:OR( NOT( ISNUMBER( InfallibleTech__Phone__c ) ), NOT( REGEX( InfallibleTech__Phone__c , "[0-9]{10}") ) )This validation is for for 10 digit phone number. If you use special characters like (,), -, etc., then you ....
In order to use Record Type Name in Validation Rule in Salesforce, check the below image
This error occur when you are trying to concatenate two fields values into a single formula field or just populating a value from a field in Formula Field which is ....
Sample: For Probability equal to 0, Probability = 0 For Probability equal to 10, Probability = 0.10 For Probability equal to 20, Probability = 0.20 For Probability equal to 30, Probability = 0.30 ....
Validation Rule: AND ( CloseDate <> TODAY(), OR ( ISCHANGED( StageName ) , DATEVALUE( CreatedDate ) = TODAY() ), Probability = 1.00//you can use isClosed = true also )
Sample Formula: NOT( REGEX( Miscallaneous__c , '[0-9]*' ) ) Cheers!!!
We have to use nested SUBSTITUTE() methods for multiple replacing of characters. Example: SUBSTITUTE(SUBSTITUTE(Name," ", ""),"-","" ) In this example, we can remove "-" and space.
