Hi, I want to app for multi condotion Exampl...

(Alice pothisut) #1

Hi, I want to app for multi condotion


Select :Condition A ,Condition B and Condition C

Result : x

What use function

for this case ?

(Levent KULAÇOĞLU) #2


SELECT(Tablename[ColumnName], AND(ConditionA, ConditionB, Condition C))

(Alice pothisut) #3

What wrong this condition ??

(Levent KULAÇOĞLU) #4

@Alice_pothisut your conditional statements’ structure shall be: [ColumnName]=[_THISROW].[ColumnName]

(Alice pothisut) #5

Error code this statements

(Levent KULAÇOĞLU) #6

@Alice_pothisut your conditional statements are with totally in wrong structure. It shall be exactly in this format:

SELECT(Tablename[ColumnName], AND( [Column1]=[_THISROW].[Column1], [Column2]=[_THISROW].[Column2], [Column3]=[_THISROW].[Column3] ) )

(Alice pothisut) #7

Ok, code is correct but on screen can’t show Actuator code


Hi, +Alice pothis Check out the documentation

on expressions

at this link. help.appsheet.com - EXPRESSIONS | AppSheet Help Center EXPRESSIONS | AppSheet Help Center help.appsheet.com

(Alice pothisut) #9

Thank you

(Levent KULAÇOĞLU) #10

@Alice_pothisut have you verified and tested your expression in the expression builder? If it’s returning a blank value, than your conditional statements might not be properly set. If you test your expression, you can see what Actuator code(s) the expression is returning.


@Alice_pothisut Hi Did you mean to have the Actuator column type as SHOW. Maybe it should be text or something else?