Formula Rich Text Field Color
I have a Formula Rich Text Field that's pretty simple: [Season]&" "&[Guarantee Type]&": "&[Guarantee Description]. How do I make the "Season" field the color Red? ------------------------------ ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this
"<font color=red>" & [Season] & "</font color>"
&" "&[Guarantee Type]&": "&[Guarantee Description]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
"<font color=red>" & [Season] & "</font color>"
&" "&[Guarantee Type]&": "&[Guarantee Description]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks Mark. Copied what you gave me and got this: <font color=red>2020</font color> Full Guarantee
Is the formula missing something? Also, I have a few child records it's accessing. Can I get it to "return" for a new line for each child record?
------------------------------
Mike McCartney
------------------------------- MarkShnier__YouIs the field type formula text or formula rich text. It needs to be the latter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- It's a Formula Rich Text field that's combining some fields from child table (Season is a text field. Guarantee Type is a text multiple choice and Guarantee Description is a text field).
Rather than making the Season a color, I now simply want to force it on a new line. For example, I have 3 Seasons, 2020, 2021 and 2022. Right now, it shows up with something like this: 2020 Guaranteed for 6 months. 2021 Guaranteed for 4 months. 2022 Not Guaranteed. Instead how do I make it:
2020 Guaranteed for 6 months.
2021 Guaranteed for 4 months.
2022 Not Guaranteed.
Here's the Formula Rich Text field: [Season]&" "&[Guarantee Type]&": "&[Guarantee Description]
------------------------------
Mike McCartney
------------------------------
