Forum Discussion

BhargaviKatepa1's avatar
BhargaviKatepa1
Qrew Member
2 years ago

Multiselect field values with customized bullet colors

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
------------------------------
  • 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.
    ------------------------------
    • BhargaviKatepa1's avatar
      BhargaviKatepa1
      Qrew Member

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

    • BhargaviKatepa1's avatar
      BhargaviKatepa1
      Qrew Member

      Will be waiting for the response, if someone could help out on this really appreciate the help:). Thanks in advance.



      ------------------------------
      Bhargavi Katepalli
      ------------------------------

      • TylerFoster's avatar
        TylerFoster
        Qrew Cadet

        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



        ------------------------------
        Tyler Foster
        Associate Developer
        Synctivate Inc.
        ------------------------------