You need to sign in to do that
Don't have an account?
Brenda Frambes 10
Validation rule not working on Picklist change
I have a custom picklist field on a Person Account named "how did they hear about us" and then a dependent picklist named Sub Category. Only some "How did they hear about us" selections require a "Sub Category". An example would be Social Media. If that is selected the Sub Category must be selected. The Validation works on New Person Account records but when I test updating a record to a picklist item that should require a Sub Category the validation isn't enforced. Here is my Validation Rule:
AND( ISPICKVAL ( PersonContact.How_did_they_hear_about_us__c , "Social Media"),ISPICKVAL ( PersonContact.Sub_Category__c , "" ))
Any suggestions? Thank you in advance.
AND( ISPICKVAL ( PersonContact.How_did_they_hear_about_us__c , "Social Media"),ISPICKVAL ( PersonContact.Sub_Category__c , "" ))
Any suggestions? Thank you in advance.
Try this:
AND( ISPICKVAL ( PersonContact.How_did_they_hear_about_us__c , "Social Media"),ISBLANK( TEXT(PersonContact.Sub_Category__c)))
If you have both these fields on a page layout, do the following things:
1. make them required from page layout.
2. Establish field dependency between these two picklists
By doing so, we can avoid validation rule.
All Answers
Try this:
AND( ISPICKVAL ( PersonContact.How_did_they_hear_about_us__c , "Social Media"),ISBLANK( TEXT(PersonContact.Sub_Category__c)))
If you have both these fields on a page layout, do the following things:
1. make them required from page layout.
2. Establish field dependency between these two picklists
By doing so, we can avoid validation rule.