Solved: How to use filter function in slice?

eusy1327 · 10-22-2021 08:45 AM

when show it data rows from spreadsheet on appsheet, I want to display only rows match some condition.please guide me.
-refer to below image-

Aurelien

I only tried to interpret your expression true(FILTER(..., [Number]=1))

You have to decide which expression (that gives a yes/no output) to apply to your slice.

Aurelien

You will find useful information below:

Basically, everything happens here:

Then, pick the source table for your UX:

EDIT:
additional references:

In your case:
the expression
[number]=1
is enough for your slice, from my understanding

eusy1327

I way try as you mention but fail, too many show the contents.

eusy1327

is will relate IMPORTRANGE function?

Aurelien

I only tried to interpret your expression true(FILTER(..., [Number]=1))

You have to decide which expression (that gives a yes/no output) to apply to your slice.

eusy1327

Thank you. I solve the issue by your mention.

eusy1327

Add Note. The source data brought through the IMPORTRANGE function.