Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Default Max Date selection in Filter pane when app opens

When I open my app, I wanted to see my max date selection in my Date field. Some one can help me on this.

Capture.PNG

Labels (3)
1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @MuraliPrasath

Did you create a new filter pane? Because that is not what you should do. Paste =Num(Date)=Num(Max(ALL Date)) into your filter pane's search box and press Enter.

Filterpane.png

It will select your max date. That is what you then save as a bookmark.

Regards,

Mauritz

View solution in original post

9 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @MuraliPrasath 

  1. Paste the following in your filter pane: =Num(Date)=Num(Max(ALL Date))
  2. Save it as a bookmark.
  3. Right click on the bookmark and click on Set selections as app default.

Hope this helps.

Regards,

Mauritz

MuraliPrasath
Creator III
Creator III
Author

Hi,

Thanks for helping me out!

I did try this one, but the below result I'm getting. I wanted to see my date list plus max date selection by default, when I open my app. Thanks. 

Capture.PNG

Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @MuraliPrasath

Did you create a new filter pane? Because that is not what you should do. Paste =Num(Date)=Num(Max(ALL Date)) into your filter pane's search box and press Enter.

Filterpane.png

It will select your max date. That is what you then save as a bookmark.

Regards,

Mauritz

poojapalni1
Contributor II
Contributor II

Thanks for hint. 

What i did is, i wrote formula in bookmark settings and its working.

 

ioannagr
Creator III
Creator III

@Mauritz_SA hello, maybe you could give me some insight on why this doesn't work on my timestamp filter?

=Num([timestamp])=Num(Max(ALL [timestamp]-maketime(08)))

CITIPK57092
Contributor
Contributor

In my case, its not picking max date, its picking all availble dates

I have added this formula - =Num(DATA_DATE)=Num(Max(DATA_DATE))

CITIPK57092_3-1691155743417.png

 

CITIPK57092_4-1691155793730.png

 

Any idea what's wrong here ?

thanks in advance!

firoz24
Creator
Creator

Hi @MuraliPrasath 

I want to get last date entered with respect to a field

I have a field called station and there are ten fields.

SO I am making 10 sheet seperate and need to get last date with respect to a station 

For eg:- Num(max)=num(max(all date)),[Station]={'Back door glass'}

firoz24
Creator
Creator

Hi @Mauritz_SA 

I want to get last date entered with respect to a field

I have a field called station and there are ten fields.

SO I am making 10 sheet seperate and need to get last date with respect to a station 

For eg:- Num(max)=num(max(all date)),[Station]={'Back door glass'}

Please check this 

firoz24
Creator
Creator

Hi @CITIPK57092 

Did you find any solution for this 

Still I have not solved this issue.