I have a requirement where I need to trigger and open another document in the same sheet as the current document.
In my example attached, if I am on abc.qvw, I should click button on sheet 1, and it should take me to abc-1.qvw and open on sheet 1 only. Same goes for all the buttons on the other sheets.
Of all things I have tried so far, I believe the transfer state happens after the 2nd document opens and it cannot calculate the value of the 'sheet id' during opening the document. Also I do not want to use a macro.