Multi select dropdown leading to conditional result

[Bacon]

I have a datapage hat allows the user to (multi) select from a list of options and once they have selected some, it provides a result. The result is dependant on what is selected.
My table is set up using a list-string of items 'HAZARDS' and each of these is either a CAT B or CAT C item.

So the user selects from the HAZARD list and if they select any that are CAT C in the table, the result is CAT C, if they only select those which are CAT B it is CAT B.

I have used the following code:
CASE WHEN '[@ICAO_CAT]' LIKE '%CAT B%' OR '[@ICAO_CAT]' LIKE '%CAT C%' THEN 'C' ELSE 'B' END 

But it is not working - it allows a multi selection, but nothing happens with the ICAO_CAT result - it remains as B regardless. I have attached the table setup to show and a screenshot of the Datapage.

How do I get it to actually change based on the ICAO_CAT shown in the table?
 

 

[CoopperBackpack]

Hello @Bacon,

Could you clarify the expected value for the 'ICAO_CAT' field when the user selects multiple values from the 'hazard' field?
For example:

For me, the table on the screenshot looks like a lookup table that stores a list of possible 'hazard' values. https://howto.caspio.com/tables-and-views/lookup-tables/

The List-string data type is used to store the multiple values in the field (so, an array of values) and has a list of restrictions https://howto.caspio.com/tables-and-views/data-types/list/

If your table is a lookup table, use Text(255) data type for the 'hazard' field instead.

When it is a Text(255) field, it can be a Dropdown and the 'ICAO_CAT' field can be a Cascading element (for example, Cascading Text):

https://howto.caspio.com/datapages/datapage-components/cascading-elements/