Anyone have a favorite trick for "upserting" to a Multi-Select Picklist in Visual Workflow? Say for instance I want to add a value only as long as it doesn't already exist.
While we're on the subject -- how about selectively removing values from a MSP?
I imagine there's a slick way to get this done with formulas. Has anyone wrapped their head around it?
The best I have come up with sofar is this. Assume MSP for color: red, yellow green. You are editing an object that has current value red. You want to set to red and yellow.
Screen:
Current value of color: Red
[x] no change
[ ] red
[ ] yellow
[ ]green
User sees current value. User can leave default of no change. Or user can set boxes to other values. In this case user would click three times to uncheck no change and click red and yellow.
Now you do assignment of the field to red;yellow by formula that uses the four foxes to compute the new value of the MPS.
