How to set a trigger to select current year when opening?

[#1]

Hi,

Could someone please advise me on how I set a trigger to select current year in the table 'YearAsOf' when opening a tab?

I know how to get to the trigger option but unsure what to select / add from here.

Many thanks.

John

[fdelacal]

triggers--- edit action on open.

Action ...Select in field

Field= (DATE)

Searching Strign

= Year(today())

Regards

[#3 · Accepted solution]

Dear go to sheet properties >>Triggers>>Edit Actions>> and follow attachment