Apex Code Development You need to sign in to do that
Don't have an account?
GoForceGo Multi-Select Country picklist Formula.
I have a multi-select country picklist with 150 entries. I want to know if the value of the field includes one of the 141 countries (let's call this Group 1). Note that the user might include values from the Group 2 countries as well. I can't write a big formula (INCLUDES(field,country1) || includes(field, country2) .....INCLUDES(field, country141)).
There is no ability to convert a multi-select picklist to a text value - If I could convert the picklist to a text value, I could use the SUBSTITUTE where there the 9 Group 2 country values and ";" are substituted by blank. If the remaining string is non-empty, I know I have a Group1 value exists.
Any other thoughts before I create a "tracking field" which is a text field and copies the multi-select field via a trigger? Even with that, I will have to assume the tracking field does not exceed 255 characters, it can't be a long text field either.
Any additional thoughts?
There is no ability to convert a multi-select picklist to a text value - If I could convert the picklist to a text value, I could use the SUBSTITUTE where there the 9 Group 2 country values and ";" are substituted by blank. If the remaining string is non-empty, I know I have a Group1 value exists.
Any other thoughts before I create a "tracking field" which is a text field and copies the multi-select field via a trigger? Even with that, I will have to assume the tracking field does not exceed 255 characters, it can't be a long text field either.
Any additional thoughts?
I haven't done this before, but perhaps you could say doesn't NOT include the 9 vaules you don't care about AND isn't null? That would be a much shorter include formula.
Jeet Padhya
Even i think this would work better!