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!
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
