select a Date field to current date, when app is first opened

[ozcano]

Hello

I want to select a Date field to current date, when application is first opened. I know that I can add action for sheet properties to do that. But that is not usefull, since that approach re-sets date when user browse to another sheet and comes back to same sheet again (therefore destroys any date selection user has made during that applicaton session). Is there any application level action (trrigger) that I can set or is there any other solution for that?

Regards, Ozcan

[LRuCelver · Accepted solution]

1. Create a Filter Box with your date dimension.
2. Clear all other filters you don't want to have as defaults.
3. Depending on whether you want the last date or today, enter either
   =Date=Max(all Date)
   or
   =Date=Today()
   into the search field and hit enter.
   
   You should have filtered the dates to a single date.
4. Create a new bookmark. Untick "Save sheet  location" if you don't want a sheet to open whenever the app is opened.
   It is important that you didn't click any values in the filter box but used the expression to filter them. This way the expression is saved in the bookmark.
   
5. Right-click your bookmark and select "Set as default bookmark".
   
   Whenever the app is opened that bookmark with your formula as the filter will be applied.