Search and change column text based on results

neozeric

The dataset has multiple states and looks like "FL AL WI NY NJ" . It also has a headquarter state with just a single entry and looks like "WA"

{ "data": null,
"render": {"_": "bstate","filter": "bstate","display": "state"}
},

That part works fine and there is a custom drop down search that allows the user to pick their state

When it matches on one of the multiple state ones, it still shows the headquartered state, confusing the user. For example if I search FL, it will still show WA in the column

How can I make it so if the selected search state is not the headquartered state, change the column displayed state to the state they searched and add text in the column that says "has office in FL" ?

Thanks in advance

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin