+ Start a Discussion
DanielBProbertDanielBProbert 

Comparing to Multipick lists validation rules

Hey,

 

I have 2 identical multi-pick lists that I would like to put a validation rule on.

 

MP 1 = Exams_Sat__c

 

Options = Exam 1, Exam 2, Exam 3, Exam 4

 

MP2 = Exams_Passed__c

 

Options = Exam 1, Exam 2, Exam 3, Exam 4

 

What i would like the rule to do is

 

IF Exam 1/2 & 4 were selected as exams Sat, when you come to set the passed exams if you select Exam 3 you get an error telling you that you have selected an exam that wasn't sat.

 

Any ideas or is this not possible?

 

Cheers

Dan

 

 

T-HanT-Han

You can use the INCLUDES in the formula for the VR.

 

(  

INCLUDES(MP1,"Exam1") &&

INCLUDES(MP1,"Exam2") &&

INCLUDES(MP1,"Exam4") &&

INCLUDES(MP2,"Exam3")

)

 

This is the main idea - syntax may/not be perfect.

KT1KT1

AND(

INCLUDES(MP1,"Exam1"),

INCLUDES(MP1,"Exam2"),

INCLUDES(MP1,"Exam4"),

INCLUDES(MP2,"Exam3"))

 

The only thing is with multi-select picklist fields is that you have to add syntex for every option so more than one validation rule may have to be made depending on the amount of options there is. The more suitable way to complete this, may be by creating an Apex Trigger.