Search and change column text based on results
Search and change column text based on results
![neozeric](https://secure.gravatar.com/avatar/c1a7123f9ef5b1287cc86f374b86b9c8/?default=https%3A%2F%2Fvanillicon.com%2Fc1a7123f9ef5b1287cc86f374b86b9c8_200.png&rating=g&size=120)
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
Answers
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