SHOW IF Expression not working
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?
Here is my expression with the working combined
=OR([Room/Item Name]=โRoofโ, [Room/Item Name]=โSidingโ)
Here is what I want it to do
=OR([Room/Item Name]<>โRoofโ, [Room/Item Name]<>โSidingโ)
They work like this
[Room/Item Name]<>โSidingโ
but not wrapped up in OR.
Am I just missing something and my brain is not seeing it?
Thank you for any help
Try
OR( NOT([Room/Item Name]=โRoofโ), NOT([Room/Item Name]=โSidingโ) )
@Simon_Robinson Tried that one and it still shows the column regardless of the content
For other readersโฆ the solution isโฆ AND([Room/Item Name]<>โRoofโ,[Room/Item Name]<>โSidingโ).
@Aleksi_Alkio, Any idea on this Aleksi?
I really appreciate it as it is putting a big road block on my app progress.
Thank you!
You got โApply show-if constraints universallyโ turned on?
yes
Sounds like a bug.
But try this just to prove that theory
Create 3 virtual columns
VC1 =
IF([Room/Item Name]<>โRoofโ,TRUE.FALSE)
VC2 =
IF([Room/Item Name]<>โSidingโ,TRUE,FALSE)
VC3 =
OR(VC1,VC2)
If itโs not a bug, this might give you an insight as to what is wrong.
Also an issue today where I had to do something like this to get it to work when a column had both integers and text:
=OR(Concatenate("",[Room/Item Name])<>โRoofโ,Concatenate("",[Room/Item Name])<>โSidingโ)
@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
Thank you
@Jason_Spicer Sounds like a bug, report it via appsheet.com - Contact us - AppSheet Contact us - AppSheet appsheet.com
@Simon_Robinson Thank you Simon for all of your help
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |