Hi Bhargavi,
Here is a rich text formula you can use!
If(ToText([Workstream]) = "", "",
"<span style='color: #FF0000'>" & "• " & "</span>" & Part(ToText([Workstream]), 1, ";") & "<br>"&
"<span style='color: #FF7F00'>" & "• " & "</span>" & Part(ToText([Workstream]), 2, ";") & "<br>" &
"<span style='color: #FFFF00'>" & "• " & "</span>" & Part(ToText([Workstream]), 3, ";") & "<br>" &
"<span style='color: #00FF00'>" & "• " & "</span>" & Part(ToText([Workstream]), 4, ";") & "<br>" &
"<span style='color: #0000FF'>" & "• " & "</span>" & Part(ToText([Workstream]), 5, ";") & "<br>" &
"<span style='color: #4B0082'>" & "• " & "</span>" & Part(ToText([Workstream]), 6, ";") & "<br>" &
"<span style='color: #9400D3'>" & "• " & "</span>" & Part(ToText([Workstream]), 7, ";") & "<br>" &
"<span style='color: #964b00'>" & "• " & "</span>" & Part(ToText([Workstream]), 8, ";") & "<br>" &
"<span style='color: #008080'>" & "• " & "</span>" & Part(ToText([Workstream]), 9, ";") & "<br>" &
"<span style='color: #FFC0CB'>" & "• " & "</span>" & Part(ToText([Workstream]), 10, ";"))
The only changes you should need to make are the colors of your bullets by changing the hex code. This example is for 10 entries in a multi-select, but if you need more simply add more lines in the same format. Your result should look similar to this:
Please let me know if you have any trouble with it!
Thanks a ton Tyler, but it willl give same colors irrespective of the values I believe. Suppose for few records we will be selecting only 4 values instead of 10. Here what I exactly want to display is if the value is "A" then red bullet, "B" green...etc. There can be multiple values, No matter on their position color should be same. Hope you got my point. Also, I don't want extra bullets to be created unnecessarily. like below.
------------------------------
Bhargavi Katepalli
------------------------------
Will be waiting for the response, if someone could help out on this really appreciate the help:). Thanks in advance.
------------------------------
Bhargavi Katepalli
------------------------------
Hi Bhargavi,
I have found a solution to this! It does require another table; I've called this table 'Colors'. All you are doing in this table is aligning one of the names in your multiselect field to a hex color. In my example you would just substitute the Color Names to the options in your multiselect. See below:
Now use this formula in the same table as your Workstream field:
//Change the value of 7 at the end to whatever the FID of your hex color field is.
var textlist colorone = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 1, ";") & "}", [_DBID_COLORS]), 7);
var textlist colortwo = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 2, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorthree = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 3, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorfour = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 4, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorfive = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 5, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorsix = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 6, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorseven = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 7, ";") & "}", [_DBID_COLORS]), 7);
var textlist coloreight = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 8, ";") & "}", [_DBID_COLORS]), 7);
var textlist colornine = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 9, ";") & "}", [_DBID_COLORS]), 7);
var textlist colorten = GetFieldValues(GetRecords("{6.EX." & Part(ToText([Workstream]), 10, ";") & "}", [_DBID_COLORS]), 7);
If(Part(ToText([Workstream]), 1, ";") <> "", "<span style='color: " & ToText($colorone) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 1, ";") & "<br>") &
If(Part(ToText([Workstream]), 2, ";") <> "", "<span style='color: " & ToText($colortwo) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 2, ";") & "<br>") &
If(Part(ToText([Workstream]), 3, ";") <> "", "<span style='color: " & ToText($colorthree) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 3, ";") & "<br>") &
If(Part(ToText([Workstream]), 4, ";") <> "", "<span style='color: " & ToText($colorfour) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 4, ";") & "<br>") &
If(Part(ToText([Workstream]), 5, ";") <> "", "<span style='color: " & ToText($colorfive) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 5, ";") & "<br>") &
If(Part(ToText([Workstream]), 6, ";") <> "", "<span style='color: " & ToText($colorsix) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 6, ";") & "<br>") &
If(Part(ToText([Workstream]), 7, ";") <> "", "<span style='color: " & ToText($colorseven) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 7, ";") & "<br>") &
If(Part(ToText([Workstream]), 8, ";") <> "", "<span style='color: " & ToText($coloreight) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 8, ";") & "<br>") &
If(Part(ToText([Workstream]), 9, ";") <> "", "<span style='color: " & ToText($colornine) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 9, ";") & "<br>") &
If(Part(ToText([Workstream]), 10, ";") <> "", "<span style='color: " & ToText($colorten) & "'>" & "• " & "</span>" & Part(ToText([Workstream]), 10, ";") & "<br>")
This is the end result:
This is quite a process, so if you have any questions about how to format anything, please let me know!
Thanks,
Tyler
