Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
You have to delete the '=' in the first field.
Than it have to work fot you.
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
Hi,
Sorry but it doesn't work...
Look what i get :
Semaine is my field name.
What's wrong with this ?
Thanks
You have to delete the '=' in the first field.
Than it have to work fot you.
It Works !!
Thanks a lot