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

Hi, I want to app for multi condotion

Example

Select :Condition A ,Condition B and Condition C

Result : x

What use function

for this case ?

0 10 364
10 REPLIES 10

@Alice_pothisut

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

What wrong this condition ??

@Alice_pothisut your conditional statementsโ€™ structure shall be: [ColumnName]=[_THISROW].[ColumnName]

Error code this statements

@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] ) )

Ok, code is correct but on screen canโ€™t show Actuator code

Lynn
Participant V

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

Thank you

@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.

Lynn
Participant V

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

Top Labels in this Space