Apex Code Development You need to sign in to do that
Don't have an account?
meighan Validation Rule: Lookup Field Required if Picklist selected
I have 3 fields that must be filled out on all accounts, either the three fields for Division A or Division B. Two are picklists that are dependent upon each other, so that is set. I still need to find out how to make two rules one that requires A or B Lookups, another that connects the lookups to the picklists.
Either Division A Lookup or Division B lookup must be filled out.
if Division A Lookup is filled out Division A Picklist 1 must be filled out also. If Division B Lookup is filled out then Division B Picklist 1 must be filled out also.
Are you looking for something like this?
AND( ISPICKVAL(PicklistField_A__c, ""), LEN( LookupField_A__c ) > 0)
AND( ISPICKVAL(PicklistField_B__c, ""), LEN( LookupField_B__c ) > 0)
These ones might work better for you:
VR1: Make either Lookup A or Lookup B required
OR(AND( LEN(Lookup_A__c ) < 1, LEN(Lookup_B__c ) < 1))
VR2: Make Picklist A required if Lookup A chosen, or Picklist B required if Lookup B chosen.
OR( AND(ISPICKVAL(Picklist_A__c, ""), LEN( Lookup_A__c ) > 0), AND(ISPICKVAL(Picklist_B__c, ""), LEN( Lookup_B__c ) > 0))
Lemme know if they work for you.
Oh yeah, and if they do, you owe me a beer!
http://beeradvocate.com/beer/profile/863/7971
Cheers! ;-)
Youre really trying hard for some Pliny arent you?
At least this time the user is in Utah which is closer to the states that have distributors of it than you and I!
No, they will probably tell you that you will have to pay ten bajillion dollars to go to Dreamforce to get some...
Sorry to highjack this question!
(but if anyone reading this can get Pliny the Elder or Pliny the Younger, please let us know!)