I have a template that runs in the table cliente , but i use informations from table registros,
Start expression that is currently in use:
select([Registros][ID],AND([Descriรงรฃo Serviรงo]=โCoxoโ,[Status]=โMediรงรฃoโ))
,
New Start expression I tried to use:
orderby(select([Registros][ID],AND([Descriรงรฃo Serviรงo]=โCoxoโ,[Status]=โMediรงรฃoโ)),[Lista de Preรงo].[Resรญduo])
It gave me the error lista de preรงo doesnโt exist in table, does the sort key use the rows and columns from the select or the target data from the workflow ?
ORDERBY() | AppSheet Help Center here in arguments it says โThe expression is evaluated in the context of the row being consideredโ so I tought it would use the columns from the select.
Is it my misunderstanding? @Steve
Solved! Go to Solution.
ORDERBY() will use the columns of the row the ID column refers to:
It seems i had missed something but got it working now , Thanks!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |