I am trying to build an app with N sheets and to have hyperlinks to navigate to any sheet from any given sheet. E.g. if I am in first sheet, I'll have links to navigate directly to 5th sheet or 6th sheet etc without having to click Next sheet icon multiple times. I don't want to use KPI or text object as these open the sheets in new tab/window. Looks like the extension it.HtmlBox can be used to embed any HTML code, so wondering if I could use it for achieving this, may be using a href or window.open (target _self) but not sure how to get the current page and sheet id to pass as parameters. Anyone has any suggestions for this?
