Skip to main content
Question

Multiselect field values with customized bullet colors

  • March 24, 2023
  • 0 replies
  • 64 views

Hi , 

I am trying to show a multiselect values with customized bullet color list using rich text field. But unfortunately I caanot , by default it is taking the black bullets not able to do the customization , can someone help me here. I just used the below code, there are 10 values in my multiselct field I want that to be represented with different color of bullets.

If(ToText([Workstream])="","",
     "<li>" & 
     SearchAndReplace(ToText([Workstream]),";","</li><li>") &
     "</li>" )



------------------------------
Bhargavi Katepalli
------------------------------
    This topic has been closed for replies.

    • TylerFoster
    • Registered
    • March 24, 2023

    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! 



    ------------------------------
    Tyler Foster
    Associate Developer
    Synctivate Inc.
    ------------------------------
    Terms & ConditionsAccessibility statement