I’m creating a new application, and i’ve got this error message
ORDERBY(SELECT(System[Sys_Label],AND([Sys_Type]=‘TYPEFICHE’,[Sys_Actif_B]=true),true), [Sys_Tri])
In table System the column Sys_Tri is present
AppSheet knows this colum because it is displayed :
What is strange is there is no error for this expression
No error for the Sys_Label column, So AppSheet knows the column Sys_Label
And when i add the Order By clause with this column
ORDERBY(SELECT(System[Sys_Label],AND([Sys_Type]=‘TYPEFICHE’,[Sys_Actif_B]=true),true),[Sys_Label])
I’ve got the error message !!
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
19 |