navigation with buttons in sheets

[Anonymous]

Dear All,

I have a QVW with a situation like:

4 Sheets

Sheet SH01     Button01 that opens a sheet SH10

Sheet SH02     Button02 that opens a sheet SH11

Sheet SH03     Button03 that opens a sheet SH10

In Sheet SH10, I have a Button04 to return to original sheet (that can be SH01 or SH02). I need a help to set a variable with the name of the caller sheet to go back in a return Button04.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Just create another action before the one that activates the new sheet that populates a new variable "vSheetFrom" with the sheet ID. Then in the third sheet, use this variable in the action.

Hope that helps.

Miguel

[Anonymous]

Thanks Miguel. 

Easy and fast

[#4]

Thanks Miguel - I needed to to make a general navigation back button so I've adapted your approach.

I added another variable so I didn't have to keep specifying each sheet:

vThisSheetID = Replace(GetActiveSheetId(),'Document\','')

I then set vSheetFrom to vThisSheetID, triggered OnLeaveSheet.

Seems to work well enough.