Format text colors and backgrounds in Multi select field

This will work to display the choices in  view mode vertically.  I have to think some more as to how the coax them to list horizontally.

var text value = ToText([My Mutli Select field]);

// parse out eah selection into separate formula variables
var text ValueOne = Trim(Part($value,1,";"));
var text ValueTwo = Trim(Part($value,2,";"));
var text ValueThree = Trim(Part($value,3,";"));
var text ValueFour = Trim(Part($value,4,";"));
var text ValueFive = Trim(Part($value,5,";"));

// red
var text ValueOneColor =
"<div style=\"color:white; background-color:#e6194b; text-align:center; width:100px; padding: 5px\">" & $valueOne & "</div>";

// Green
var text ValueTwoColor =
"<div style=\"color:white; background-color:green; text-align:center; width:100px;padding: 5px\">" & $valueTwo & "</div>";

// Black
var text ValueThreeColor =
"<div style=\"color:white; background-color:Black; text-align:center; width:100px;padding: 5px\">" & $valueThree & "</div>";

// Blue
var text ValueFourColor =
"<div style=\"color:white; background-color:Blue; text-align:center; width:100px;padding: 5px\">" & $valueFour & "</div>";

// Black
var text ValueFiveColor =
"<div style=\"color:white; background-color:yellow; text-align:center; width:100px;padding: 5px\">" & $valueFive & "</div>";

// now list then all together with a separator of a space.

List(" ",
If($ValueOne <>"", $ValueOneColor),
If($ValueTwo <>"", $ValueTwoColor),
If($ValueThree <>"", $ValueThreeColor),
If($ValueFour <>"", $ValueFourColor),
If($ValueFive <>"", $ValueFiveColor))



// for the background colors you can use words and Quickbase will recognize the common colors.  Here is a list of 20 colors
Red e6194b
Green 3cb44b
Yellow ffe119
Blue 0082c8
Orange f58231
Purple 911eb4
Cyan 46f0f0
Magenta f032e6
Lime d2f53c
Pink fabebe
Teal 008080
Lavender e6beff
Brown aa6e28
Beige fffac8
Maroon 800000
Mint aaffc3
Olive 808000
Coral ffd8b1
Navy 000080
Grey 808080
White FFFFFF
Black 000000

I used the hex code for red in the first part.  You need to preface the hex code with #.


​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------