Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Visualize a specific sheet on open

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 ?

8 Replies
Nicole-Smith

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.

Anonymous
Not applicable
Author

Luca

Some Triggers, especially 'On Open' Triggers do not work with the Ajax Web Client.

Best Regards,     Bill

Nicole-Smith

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()))

Anonymous
Not applicable
Author

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.

Nicole-Smith

Did you put the full SH01 or just the number?   You need the full ID.

Anonymous
Not applicable
Author

i put SH01

Anonymous
Not applicable
Author

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

Nicole-Smith

For a variable you need Settings > Document Properties > Triggers > On Open > External > Set Variable

VisibleSheet

0

Do not put =0, just 0.