You need to sign in to do that
Don't have an account?
JRBAccruit
Require Multiple Fields based on Picklist Value Selected
All,
I'm probably just not thinking clearly, but how can I require the completion of several fields based on the selection of a certain value in a picklist field?
I could do a series of Valudation rules (one for each field I need completed), but that sounds a bit inefficient . . .
Thanks!
I'm probably just not thinking clearly, but how can I require the completion of several fields based on the selection of a certain value in a picklist field?
I could do a series of Valudation rules (one for each field I need completed), but that sounds a bit inefficient . . .
Thanks!
All Answers
for example knowing the one field is a picklist:
Any thoughts?
Yes - that was why the comment about using the different methods for null. The method I gave works only for text.
You probably need to use ISNULL(field1) for example
ISPICKVAL( Type ,"Customer"),OR(ISNULL( BillingStreet),ISNULL( BillingCity),ISNULL( BillingState ),ISNULL( BillingPostalCode ),ISNULL( Billing_Attn_Line__c ))
)