+ Start a Discussion
Venkata Sumedha singanamalaVenkata Sumedha singanamala 

Please Help me with the Validation Rules


I have a requirment where there are two Custom Fileds 1.) Identification Details 2.) Identification proof here identification is a text data type and Identification Details is of Picklist which consists of an option of selecting SSN # I know that the field dependency cannot be applied for Identification proof since it is a text data type so I want to give a custom validation saying if the user selects the SSN# then the format of the SSN should be like "1234-4567-125" and whenever the identification detail is selected then the Identification proof must be made compulsory field.

Hope you understand my requirment please help me with this.

Vatsal KothariVatsal Kothari

you can refer below validation rule:
IF(ISPICKVAL(Identification_Details__c,'SSN #'),IF(NOT(REGEX(Identification_Proof__c,"[1-9]{4}-[1-9]{4}-[1-9]{3}")),true,false),false)
If this solves your problem, kindly mark it as the best answer.