Discussions

 View Only
  • 1.  Formula Rich Text Field Color

    Posted 06-21-2020 17:04
    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
    ------------------------------


  • 2.  RE: Formula Rich Text Field Color

    Posted 06-21-2020 21:11
    Edited by Mark Shnier (Your Quickbase Coach) 06-21-2020 21:11
    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
    ------------------------------



  • 3.  RE: Formula Rich Text Field Color

    Posted 06-22-2020 06:06
    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
    ------------------------------



  • 4.  RE: Formula Rich Text Field Color

    Posted 06-22-2020 07:29
    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
    ------------------------------



  • 5.  RE: Formula Rich Text Field Color

    Posted 06-22-2020 08:44
    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
    ------------------------------



  • 6.  RE: Formula Rich Text Field Color

    Posted 06-22-2020 09:10

    Try this

     [Season]&"<br> "&[Guarantee Type]&": "&[Guarantee Description]



    ------------------------------
    Paul Peterson
    ------------------------------