Multi User Select Field Colorization
I am wondering if it is possible to colorize a multi-select field gracefully on a report. For example, I would like to assign each option in the field a color, but if two or more are selected I want a...
Forum Discussion
What you will want to do is create a formula text field that converts those entries into colorized text.
It will need to evaluate each option that is there, and assign a color.
It will be a List function, with some if statements.
List(", ",
If(Contains([Name], "Jack"), "Blue Text", ""),
If(Contains([Name], "Carol"), "Red Text", ""),
If(Contains([Name], "Barbara"), "Purple Text", ""),
If(Contains([Name], "Janet"), "Yellow Text", "")
)
I'll need to circle back to this to make that text become colorized.
It will need to evaluate each option that is there, and assign a color.
It will be a List function, with some if statements.
List(", ",
If(Contains([Name], "Jack"), "Blue Text", ""),
If(Contains([Name], "Carol"), "Red Text", ""),
If(Contains([Name], "Barbara"), "Purple Text", ""),
If(Contains([Name], "Janet"), "Yellow Text", "")
)
I'll need to circle back to this to make that text become colorized.
- should I be able to copy and paste directly into my formula field where it created four rows, or should it be one row that wraps? I cannot get it to work. :(
------------------------------
Kristen Francis
------------------------------- MarkShnier__You
Qrew Legend
I think that it would help to elicit a response from the community if you posted a complete question as to what you are trying to do, in a new post and then perhaps reference this post in a link.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
