Hello,
I’m using a multiselect menu field to pick more than one item on the listing (e.g. Industry).
For example, there are several types of authorities such as transport, healthcare, etc. An authority working in the transport sector, I’d select and assign the value “Authority” and “Transport” to that organization. Do the same for another authority working in the healthcare section by using the value “Authority” and “Heathcare”.
When searching for organization (under Accounts), selecting “Authority” will display all organizations with the “Authority” assigned. If I’d like to be more specific, selecting both “Authority” and “Transport” will pull up a listing of all transport including healthcare authorities. How can I get the search result to use the AND functionality instead of OR? I’d like to avoid creating another field showing a subset of an industry in order to achieve the AND functionality.
Thanks,
Devin