Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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.
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.
Okay let me try once and get back to you.
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.
Check the qvw
Same was mentiond above by Rudolf Linder
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?