Row filter condition

[aminsaleh]

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 

[jaichith]

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)

[aminsaleh]

@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 

[jaichith]

Try this

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

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

[aminsaleh]

@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.

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.

[jaichith]

Only expression can help u....

[aminsaleh]

@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

[jaichith]

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

[jaichith]

2nd option.

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

[aminsaleh]

@jaichith 

It gives this error

[jaichith]

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.  

[jaichith · Accepted solution]

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. 

[aminsaleh]

@jaichith  Here is what I got for the second idea

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. 

[jaichith]

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

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

[aminsaleh]

@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