NOT() with multiple criteria?

David_Hundt
Participant III

I’m trying to make an action button not appear under two conditions. I can do this for one condition, but can’t figure out the syntax for two conditions. It seems like it should be straightforward, but after spending a bunch of time trolling the boards and reading up on NOT(), OR(), AND(), SELECT(), etc, I just can’t make it work. This expression does what I want for one condition:

I basically want to add another item to that list called “PNP”, so the action button wouldn’t appear for PSA or PNP. Both are in SHORT NAME.

Thanks for any assistance for this newbie.

Solved Solved
0 3 263
1 ACCEPTED SOLUTION

Thank you, @Suvrutt_Gurjar ! I added NOT in front of the expression and it worked perfectly (see below). I really appreciate your help. I learned several new things from examining your expression.

NOT(OR([SHORT NAME]<>“PSA”,[SHORT NAME]<>“PNP”))

View solution in original post

3 REPLIES 3

I may have misunderstood your requirement. I that case please give more details.

Based on current understanding, does following help?

OR([SHORT NAME] <> “PSA” , [SHORT NAME] <> “PNP”)

Assumes [SHORT NAME] is a text type column.

Thank you, @Suvrutt_Gurjar ! I added NOT in front of the expression and it worked perfectly (see below). I really appreciate your help. I learned several new things from examining your expression.

NOT(OR([SHORT NAME]<>“PSA”,[SHORT NAME]<>“PNP”))

Hi @David_Hundt,

Nice to know you figured it out. All the best with your app building.

Top Labels in this Space