+ Start a Discussion
SFDC_Dev_2009SFDC_Dev_2009 

Validation rule for dependent picklists

 

AND( ISPICKVAL(Type_of_Medical_Position__c , "Medical"), ISPICKVAL(Medical_Position__c  ,""))

 

The above validation works only for specific picklist values like "Medical"

 

I need to validate a dependent picklist field and make it required when some of the values in a controlling picklist is selected and it can be of any value.

Also for some of the values in Controlling picklist field, the dependent picklist is disabled and in that case it should not display the Error Message.

 

 

Help Needed!!

 

SFDC_Dev_2009SFDC_Dev_2009

I modified the rule and it works fine for any value selected in the controlling field,But it displays error message for some values where the dependent field is disabled

 

AND( LEN(TEXT(Type_of_Medical_Position__c )) > 0, ISPICKVAL(Medical_Position__c  ,""))

 

hsje ajksehsje ajkse
Some of the values in Controlling picklist field, the established picklist is disabled and in that case it must now not show the Error Message. Learn more (https://cdncare.ca/vascular-ultrasound/) about it.