Apex Code Development You need to sign in to do that
Don't have an account?
netTrekker_AD How can I make a VR where a multi-select picklist value cannot equal the value of another field?
I have a multi-select picklist field (called GVP States) on a custom object where a user can select one or more states. This object is related to Opportunities. I want to make an Opportunity Validation Rule that says "The Account Billing State/Province must equal one of the GVP States values". I understand that multi-select picklists have a very limited number of functions that can be used with them, so I am unable to figure out how to work this. Any ideas for a work around?
Is this possible through a CASE function or something?
Since you want to implement a validation rule which is cross object and also involves multiselect values , the best route would be to write a trigger for the concerned object, though it will take some effort but it would be a clean implementation.
Hope this helps.
Thank you Ispita.
I decided just to change the multi-select picklist to a text field with validation rules around what can be entered to make the VR in question work.