Hi, I had a play with multicoloured dots today following the above answer and i found a slightly better method by using movie_color=case(somefield=number or "string", "#colour",someotherfield=number or "string","#colour", 1=1,"#colour for everything else")
This way you can have as many Boolean cases as you need rather than nested if statements.
Regards Lloyd
... View more