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.
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. ------------------------------
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.
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);
