Sheet Navigation

[vardhancse]

Hi Team,

I have one requirement is that.

I have one dashboard with below mentioned sheets

Home page

5 sheets in dashboard,

6th sheet was a help/glossary sheet.

If I open glossary sheet from Sheet_5 of a dashboard using a button action. Now I want a button in glossary sheet to go back to the Sheet_5 instead of home page.

Similarly for all the sheets, when ever I open Glossary sheet from one sheet in a dashboard. I should go back to that page only.

[#2]

Sorry, i thought you're still stuck at same problem.

[Anonymous]

Hi Sasi.

Try this:

1. Create a variable (CTRL+ALT+V) called vReturnSheet
2. Also create variable called vShowHelpGlossary
3. Go to your help/glossary sheet

   1. Make conditional show on Properties > General: vShowHelpGlossary = 1

   2. Take notice on your ObjectID name in the help/glossary sheet!
   3. Create button in the sheet and

      1. Add variable: vShowHelpGlossary with value 0

      2. Add an ActivateSheet (in the layout action type). SheetID is =vReturnSheet
4. Create a button on one of your 5 sheets
5. Go to button Properties  > Actions

   1. Add variable: vShowHelpGlossary with value 1

   2. Add a second variable: vReturnSheet with value =Replace(GetActiveSheetId(),'Document\','')
   3. Add an ActivateSheet. SheetID must be the same as noticed in no. 3b above
6. Copy the button to the other 4 sheets as a linked object

Now test and see that it all works ;o))

Best Regards,

Johnni Kirstein

[sunilkumarqv]

on glossary sheet  Create a button - on actions Activate sheet -sheetID

[Anonymous]

When you have created the button, go to Properties > Actions

Add a variable from External > Set Variable. On the right set the Variable to "vShowHelpGlossary" and the Value to "0".

Then add another action from Layout > Activate Sheet. Again on the right set Sheet ID to "=vReturnSheet"

I hope this would help you,

Johnni