Hi,
I am trying to activate the current sheet in document chaining.
I am on App1 on Sheet 2 which has a button which takes me to App2. I want to go to Sheet 2 in App2 i.e current sheet on App1.
I am trying two options : 1. Inline table with all sheets and Sheet ID ,the SheetID is transferred through Transfer state and on App2 I have put a trigget on OnOpen Trigger of the document to Activate Sheet and assigned the SheetID filed. But this is not working. If I hard code the SheetID it seems to be working.I have checked the value of SheetID and it is correct.
2. I have also used Varaible value to transfer the value of the variable but again this is not working.
Can someone help me here?
Thanks!