Select value in a field when sheet activation

[christophebrault]

Hi,

On my application, i'd like to select the curent week in a selection object when the sheet is opened.

In propriety of the sheet, i go to triggers and add action on the sheet, selection and select a field. Is it the right way ?

But then, i don't know what expression in have to use...

How can i do this ?

Thanks,

[#2]

Hi Christopher,

What you should do is:

- make a variable in your script or frontend that generate the current week like week(today())

- make a trigger OnActivateSheet --> Select in Field --> fill in the variable

Succes, Halmar

[christophebrault]

Hi,

Sorry but it doesn't work...

Look what i get :

Semaine is my field name.

What's wrong with this ?

Thanks

[#4 · Accepted solution]

You have to delete the '=' in the first field.

Than it have to work fot you.

[christophebrault]

It Works !!

Thanks a lot