[dlindy]

We have vendor who work in multiple geographic areas. We have a multiple select field in which users can select from 1 to 69 different territories and assign them to these vendors. When we try to use available filters in a search to find the vendors who service the target territories, this custom Multiple Select field is not available for filters and therefore cannot be used in a dashboard setting. Looking to know a way via script or formula to only the fly to comma or pipe separate the selections and concatenate their values into a single custom field that can be searched/filtered.

Multi-select field

Value 1

Value 2

Value 3

Formula Field

Value 1|Value 2|Value 3

Thanks,
This is a cached copy. Click here to see the original post.

[k_dunc]

There may be a couple of ways to do it, but my suggestion would be to create a Suitelet. A Suitelet essentially is a scripted custom form. On the form you can have the fields you need for filtering purposes, then upon the user selecting their criteria, the code will then display the results in a Sublist.

[Author]

Posts