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 ?
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
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.
@Alice_pothisut Hi Did you mean to have the Actuator column type as SHOW. Maybe it should be text or something else?
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |