Set default max Date on open application and on clear all action

[razvan_brais]

Hy guys , I would like to set as Default selection my max(Date) when I open the app and when I hit the clear all button.

I have added 3 actions on my sheet properties:

1. Clear All

2.Select in Field

  a.FIELD : Date

  b. SearchString : =max(Date)

3.Lock Field

  a. FIELD : Date

But when I hit the clear all button , it clears all the selections.

When I hit the clear all button I would like to select max(Date). How can I do that?

Thank you.

[nagarjuna_kotha]

try to create that in backend and use it .

Ohterwise u have to in every expression like @jontydkpi said.

-Nagarjun

[razvan_brais]

Okay , but I always want to select the max date from that list box , the problem is I will always have a new date every day. Such as today() function.

[nagarjuna_kotha]

No worry about it , it select max of date on every day.

-Nagarjun

[sampada0810]

set it on a variable in a trigger in document properties.

[bharani8]

stalwar1‌ - Ur expertise required on this.. Even am stuck with same issue

[razvan_brais · Accepted solution]

Hey,

I solved the issue. First action that I set on button is Clear All , and the I added a new action for "select in field"

With Date as Field and expression : =max({1} Date ) as "Search String"

[bharani8]

Thanks a Lot!! Working Perfectly!!