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
------------------------------
Original Message:
Sent: 06-22-2020 07:28
From: Mark Shnier (YQC)
Subject: Formula Rich Text Field Color
Is 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
Original Message:
Sent: 06-22-2020 06:06
From: Mike McCartney
Subject: Formula Rich Text Field Color
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
Original Message:
Sent: 06-21-2020 21:11
From: Mark Shnier (YQC)
Subject: Formula Rich Text Field Color
Try 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
Original Message:
Sent: 06-21-2020 17:03
From: Mike McCartney
Subject: 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?
------------------------------
Mike McCartney
------------------------------