Row filter condition

AppSheet AppSheet Q&A
, , ,
1

Hi, in the Row filter condition of a slice

If I put a filter to show only today date orders then If I try to search for order with old or future date I get nothing. How can I solve it plz.

Thanks

2

Share your row filter expression.

If you want today date orders.

Contains ([order date] , Today() )

If you want orders other than today date.

If([order date] <> today(), true , false)

1 Like
3

@jaichith

Thank you very much,

I want a filter expression so that today dates come at the top while all other date are not hidden, will be down of the today date row.

Note: Other date may be past or future date.

Thanks

4

Try this

OR(
[YourDateColumn] = TODAY(),
[YourDateColumn] <> TODAY()
)

If it is not working… I will find some other solution

2 Likes
5

@jaichith Thank you very much for your time. But sorry it did not work for me.

let me give more detail.

By the way I am using this in the view section. I’ve tried to remove it and did not work as well.

sort by.jpg
sort by.jpg1268Ă—463 54.6 KB

Here is what I want to achieve. See today’s date in red arrow - it comes second row but I want today date to the top. and the next rows sort all other date in descending order.

date.jpg
date.jpg295Ă—337 16.8 KB

6

Only expression can help u…

1 Like
7

@jaichith

Yes I have removed the sorting date on view section.

now I am only using the expression… did not work

May I give you the edit link to try plz

8

ORDERBY(
FILTER(
“YourTableName”,
OR(
[DateColumn] = TODAY(),
[DateColumn] < TODAY()
)
),
[DateColumn],
TRUE
)

1 Like
9

2nd option.

ORDERBY(
FILTER(
“YourTableName”,
TRUE
),
IF([DateColumn] = TODAY(), 0, 1),
[DateColumn],
TRUE
)

10

bro,

I think 2nd expression may be helpful to you. I have another idea ---- create 2 slice with row filter condition today () and 2nd slice with other than today().

create 2 views for each slice and make them as ref.

create dashboard view and add those 2 views of slice in it.

put them one below other.

1 Like
11

@jaichith

It gives this error

Untitled.jpg
Untitled.jpg723Ă—460 26 KB

12

In AppSheet, you cannot directly achieve the desired sorting behavior within the row filter condition itself

I have another idea ---- create 2 slice with row filter condition today () and 2nd slice with other than today().

create 2 views for each slice and make them as ref.

create dashboard view and add those 2 views of slice in it.

put them one below other.

Another option :

create a table or slice which has virtual column types as list :

use the expressions which I have given. It will pulls up the rows as inline view of ref.

13

@jaichith Here is what I got for the second idea

Untitled2.jpg
Untitled2.jpg720Ă—398 29.7 KB

I do not see appsheet is smart enough for such thing.

It only sorts date ascending or descending

for example:

First row: Sept 10, 2023 (postponed order)

Second row: Sept 8, 2023 (Toady order)

Third row: Sept 5, 2023 (Order on 3 days ago)

appsheet should be smart to allow today’s orders date to be at the top … and all other dates under it.

14

No. you cannot sort anything in appsheet slice row filter condition.

Please try suggestion which I have given above ( 2 slice - 2 views)

1 Like
15

@jaichith Thank you very much for teaching me cool subject about dashboard. Yes I am able to do it via dashboard but I would love to have done via row filter.

anyway thank you very much indeed