Default Sheet to show on open

[#1]

Hi,

Please look into below screen shot from the screen shot i have Dashboard frm that i have sheets starting from shair main dashboard to Trendingand am displaying all sheets with condtional display using the belowcondition for  shair main dash board sheet =[ShairA&I]='SHAIR MainDasboard' and for Infrastructure sheet am using

=[ShairA&I]='SHAIR Main Dasboard/Infrastructure'...............for all sheets....

here what i want is when ever we open the Dashboard it should open withthe Shair main Dashboard sheet this is the start up page of thedashboard,,,, suppose if we save the Dashboard in Server sheet if weopened next time instead of opening with Server Sheet it should openwith Shair Main Dashboard sheet.......

Regards,

Anil

[Jason_Michaelides]

Settings > Document Properties > Triggers

Set a Layout > Activate Sheet action OnOpen.

Hope this helps,

Jason

[jagan]

Hi,

Do the following

Settings Menu -> Document Properties -> Triggers -> Document Event Triggers (on Open) -> Add -> Layout -> Activate Sheet-> Give sheet name (you required).

Hope this helps you.

Regards,

Jagan.

[#4]

   Hi,

       Jason/Jagan thanx for your quick reply i have tried this but no use after applying this i saved the file and reopened but its opening where i was closed the file not opens from Shair Main Dashboard.

please suggest  any  other way if we have

Regards,

Anil

[Jason_Michaelides]

Can you post your app?

[jagan]

Hi Anil,

Make sure that you given the Sheet ID instead of Sheet Caption.

Regards,

Jagan.

[#7]

  Yes i have given Sheet Caption only earlier i have changed sheet id with sheet name for other requirement i.e   coditional display of sheets..

Not able to upload the sample file its huge file......

Regards,

Anil

[Jason_Michaelides]

So are you using the caption or the ID in the Action?

[kuba_michalik]

So, you are showing a sheet based on selection in a field. Selection state gets saved too, and because of that you can activate the sheet with an Action all you want, but if a sheet is invisible, it just won't work 🙂

Do put an Action on OnOpen, but make it Select in Field. Field=[ShairA&I], Search String='SHAIR MainDasboard'. The sheet should show automatically.

[#10]

Jason,,Am using caption only not ID....

Any way i have attcahed sample file here,, whenever we opened the Dashboard it should start with SHAIR Main Dashboard sheet.........fro mattched file i already applied the condition......

Regards,

Anil