Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to create a User Preferences sheet in my app where the user can select/set things like the default sheet that opens when the app is opened.
So here's what I did to accomplish this (needless to say, it's not working): In the script I created an inline table of sheet names and sheet IDs similar to:
[Sheet List]:
Load * inline [
sheet_name, sheet_id
Dashboard, dashboard
Foo, foo_123
Bar, bar_id
];
I then created a User Preferences sheet with a list box that displays sheet_name.
Next I defined a variable under Variable Settings: vDefaultSheetID = %sheet_id
Lastly I defined a document Open Action to set active sheet = vDefaultSheetID.
What am I doing wrong?
Thanks,
Steve
See attached application on how this can work
Trigger OnOpen used
Hi Steve,
Go to Document properties and Add one "Document Event Trigger"
OnOpen--> Add Action-->Layout---> Activate Sheet--> In Macro Name "SH01"
SHO1 is sheet name
Thanks,
Selva
Are the clients using Ajax (Webview) or plugin?
Actions and triggers doesn't always work i Ajax.
Hi Jerry,
Any alternative?
Thanks,
Selva