I am trying to do a SHOW IF expression to show columns if they do not equal a value in a ENUM column in the table.

The expressions by themselves work with the <> value, but as soon as I wrap them together with an OR expression, they don’t work and show the column.

But, if I keep the combined expression and change the <> to = (which is the opposite of what I am trying to do), the expression works and hides the column unless either of the two values are chosen. Shouldn’t it work with the <> too?

@Simon_Robinson, @Aleksi_Alkio Apparently, it looks like you cannot have a more than one <> in an expression in a SHOW IF constraint. I have tried every variation and expression component I can find and it will not work, but if I change all the <> to =, it works. I can get it to work with the =, but if someone adds a new item to my enum list, I will have to add that additional item as a new expression, for 30+ columns each time someone adds one. I just want to have certain columns to show if they are not a certain value in my enum list. That way, if new ones get add, I don’t have to add more expressions.

I appreciate any help I can get to get this to work as I am about to scrap a months worth of work (time not spent with my kids and family) building this app