Sintaxe ORDER BY and FILTER

AppSheet AppSheet Q&A
,
1

Friends,

I’m having trouble improving this expression.
The expression is included in PDF creation.
Only the [NOME_PESSOA] column is referenced.
The expression works correctly, but it does not sort the names in ascending order.
I tried a few times to treat this field, but to no avail.

<<Start: ORDERBY(FILTER(“DB_CHAMADA”,
AND( ([ID_DATA_CHAMADA]=[_THISROW].[ID_DATA_CHAMADA]),
([PRESENCA]=”SIM”)
)
),
[NOME_PESSOA], TRUE,
[PRESENCA], ([PRESENCA]=”SIM”)
)>><<[NOME_PESSOA].[NOME_PESSOA]>>

deltai_0-1701199190050.png
deltai_0-1701199190050.png827×607 39.6 KB

deltai_1-1701199226375.png
deltai_1-1701199226375.png771×487 26.1 KB

2

ORDERBY uses [NOME_PESSOA] key values. Use [NOME_PESSOA].[NOME_PESSOA] instead.

Also I am not sure [PRESENCA], ([PRESENCA]=”SIM” actually does. Do you need it??

3

Hello,

Thanks for your solution.

How i dont see my mistake? Rrrrrr

Please, let me make other question about this PDF: How to do download this file directly in smartphone after bot works?

4

The second parameter of orderby() is descending? and expects a TRUE/FALSE value, but it is false by default. If you want ASC, I think you want a FALSE there.

ORDERBY(FILTER(“DB_CHAMADA”,
AND( ([ID_DATA_CHAMADA]=[_THISROW].[ID_DATA_CHAMADA]),
([PRESENCA]=”SIM”)
)
),
[NOME_PESSOA], FALSE,
[PRESENCA], ([PRESENCA]=”SIM”)
)

5

AFIK, you cannot do that. You either send it attached to email or send the link so the person can download it manually.

6

Right,

I do this creating field PDF and include the PATH. Its works for me.

Thanks