Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Created by Guest
Created on Jan 27, 2023

Ability to use buttons in dynaranges

It is possible to put an icon in a dynarange and use that with a hyperlink to do certain things (open new report with certain variables set, trigger a macro, etc), however it requires a bit of advanced knowledge. A button would offer all the Actions we now have (and will continue to develop), making it easy for the average user to do this.

This could be useful because one might want to set certain variables based on different rows/values within the dynarange, which now is only possible in certain situations and requires a bit of heavy lifting from the hyperlink function. Additionally, there are certain things that can not be done in a dynarange (refresh a report for example) if it is wrapped in an IF statement or anything, and the button would hopefully solve that problem.

  • Guest
    Oct 31, 2023

    In my opinion, all this can be done already. To refresh a report, you may just write a random value in a dummy cell on the same sheet using the HYPERLINK() function within a dynarange and the sheet will be refreshed.

    It is true that for some features you need either tweaks like the one mentioned above or "heavy lifting". But with HTML rendering activated you have a lot of possibilities e.g. with the HTML method "onclick" in combination with "Jedox.wss.macro.exec"

  • Guest
    Jan 27, 2023

    Also applies for comboboxes