How to create a colour picker in Jedox?
Jedox has a wide range of possibilities when it comes to reporting since it is working based on Excel technology. Having that in mind it might happen that sometimes you will need to add a colour picker to your dashboard.
Here is an example of how it could be done.
On the spreadsheet, you can put the colours which could be chosen
Set up a macro which will be trigged when colour is clicked
="<a href=""#"" title='"&U5&"' style=""height:100%;width:100%;display:inline-block;color:"&U5&";background-color:"&U5&";"" onclick=""Jedox.wss.macro.exec([true,['Module1.saveColorToVariable','"&V5&"']])""> </a>"
Create the macro in the Macro Editor
function saveColorToVariable ( $color )
{
define_variable ( 'varColor' , $color );
//return do_close();
}
That is it!! In case you are not a person who has much sense for colours, there are amazing patterns of colours on this website.
An example of the project can be found here....