Tips and Tricks
Mingle Tips and Tricks
Mingle Tip
Dynamic colors via a managed text list
Mingle Tip posted June 25, 2009 by Matt Quagliana
1683 Views, 5 Comment
Tip Name:
Dynamic colors via a managed text list
Tip Description:
I've been working on a way to represent different colors on a dashboard based upon the status of a property. Today I came up with the attached example of how to do this.
To summarize, there is a managed text list property containing the values, Green, Yellow and Red. When you select one from the list, it changes the color displayed on a corresponding report on the overview.
The table that displays the color is built "by hand", ie each cell contains a value query. For the status cell I use two queries, one for the color code and one for the text. (Each of these returns the same value.)
Screenshot:
Attachment:
colors.mingle (7KB)
Comment
Matt,
How do you get the background colour in table?
I'm being a bit thick......
Can we have an example of the wiki markup
I can see how you could change the text colour but background?
Russ
I encourage you to download the Mingle file that was attached to the original post.
That being said... you can set the background color of a table cell with this syntax: {background:yellow} or {background:#dde}
--
Matt
Matt,
Thanks for that, yes I did download it but there were 30 files in it and didn't know what to do with them?
Are there any other hidden gems for wiki as I couldn't find the background option in the help pages?
Cheers
Russ
Hmmmm... I think your browser unzipped the .mingle file, which is not helpful. I've had this problem on occasion... you need to download the file as is, with no post processing.
The markup format is called Textile... the reference is available here: http://redcloth.org/textile
It's also worth checking out Tom & Sugi's enhanced table macro, that gives a couple of cell colouring options, based on the colours assigned to the properties: enhanced table macro