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-
Solved! Go to Solution.
Hi @eusy1327
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.
Hi @eusy1327
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
I way try as you mention but fail, too many show the contents.
is will relate IMPORTRANGE function?
Hi @eusy1327
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.
Thank you. I solve the issue by your mention.
Add Note. The source data brought through the IMPORTRANGE function.
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |