OR expression works like a AND expression in SHOW_IF

[Willem]

Hello all,

I'm having trouble with the OR() expression in SHOW_IF. It seems that appsheet sees this as an AND() expression, I have this problem in multiple forms. Is there a solution for this?

Previously this worked well.

Thanks in advance!

[WillowMobileSys · Accepted solution]

@Willem 

Taking a suggest from @Marc_Dillon,  maybe it will help to describe to you in English what the expression is expected to do.

in your example you have an expression meant to be like this:

Show_If for [Col3] --- OR( ISBLANK( [col1] ) , ISBLANK( [col2] ) )

In english the result of this expression is: 

• Show Col3 IF Col1 is blank
• OR Show Col3 IF Col2 is blank
• OR Show Col3 IF BOTH Col1 and Col2 are blank
• OR DO NOT show Col3 if both have a value

The misunderstanding might be in the way OR's work.  OR's return FALSE only if ALL of the internal conditions are FALSE.   If any or all of the conditions are TRUE, the OR returns TRUE.