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.

[Anonymous]

I would use a variable to determine from whichsheet I came

let's say you define a variable vPrevSheet

you are on Sheet 5 and you goto Sheet6 (glossary sheet)

you define a Trigger OnLeaveSheet and define vPrevSheet=5 (better take SheetId)

on Sheet 6 you define a button with Activate Sheet and give your variable vPrevSheet

on each Sheet you Need to define a onleavetrigger!

[vardhancse]

Hi,

Thanks for the reply, I am looking for the dynamic change of the said variable vPrevSheet.

So that from what ever sheet I went to Glossary I should come back to the same sheet.

[Anonymous]

Hi,

Please have a look:

Go to Previous Active Sheet

Hope it will helpful!!

[Anonymous]

I donot understand?

you are on Sheet 5 and onleavetrigger you define vPrevSheet = SheetID5

you are on Sheet 4 and onleavetrigger you define vPrevSheet = SheetID4

etc.

button onglossary sheet have Action activate sheet and give variable vPrevSheet and there you go

I implemented that solution for one of my customer and it works.

[vardhancse]

Okay let me try once and get back to you.

[#7]

Hi,

Suppose you have two sheets with sheet id SH01 and SH02 respectively.

-In sheet properties, Select set onLeaveSheet trigger by setting a variable eg. vPrev  with value 'Document\SH01' and do similar for different sheet id's in respective sheets.

-Create Button, set action for activate sheet and give sheet id as $(vPrev)

It will take you to previous active page.

[kavita25]

Check the qvw

[vardhancse]

Same was mentiond above by Rudolf Linder

[Anonymous]

I cannot upload small example, so let me explain:

define your onleavetrigger: vPrevSheet with value "SH01" (first sheet)

same with yourother sheets

define your button with actionactivate sheet: =vPrevSheet

I have a new app with only 4 Sheets and it works.

where is your Problem? can you post sample app?