Apex Code Development You need to sign in to do that
Don't have an account?
Venkata Sumedha singanamala Please Help me with the Validation Rules
Hi,
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.
Regards
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.
Regards
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.Thanks,
Vatsal