Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a project with multiple sheet published on a server.
Every time someone made the log in the project must start with the sheet called "Homepage".
I tried this but doesn't work
Settings Menu -> Document Properties -> Triggers -> Document Event Triggers (on Open) -> Add -> Layout -> Activate Sheet-> Give sheet name
Any suggestion?
I also have some field. Two of them are YEAR and MONTH. I'd like set them to the current date on project opening (in this case 2012 and 12). Is that possible ?
You need to give the Sheet ID (right click on the sheet, then go to Properties > General to get the ID) instead of the name.
Luca
Some Triggers, especially 'On Open' Triggers do not work with the Ajax Web Client.
Best Regards, Bill
For the date stuff, where is December 2012 coming from? Or did you mean December 2013?
If you want it set to the current month and year of today:
Settings > Document Properties > Triggers > On Open > Select in Field
YEAR
=year(today())
MONTH
=num(month(today()))
Doesn't work on my client project neither....
The selection of field value (nicole's answer) works but the selection of the sheet doesn't.
I put the identifier of the sheet, not the name.
Did you put the full SH01 or just the number? You need the full ID.
i put SH01
i have understand the problem.
My homepage (SH01) have a conditional function.
It can be shown only if my variable "VisibleSheet" = 0
If i put
Settings > Document Properties > Triggers > On Open > Select in Field
VisibleSheet
=0
in the same way of YEAR and MONTH doesn't work
For a variable you need Settings > Document Properties > Triggers > On Open > External > Set Variable
VisibleSheet
0
Do not put =0, just 0.