Discussions

Expand all | Collapse all

Color Fields

  • 1.  Color Fields

    Posted 23 days ago
    Good Morning,

    I am trying to color fields red and green. I have rich text options but it keeps giving me errors.
    I've tried many different formulas. Can someone guide me in the correct direction?

    <font color=red>" & [2020 Chronic Vs Acute Status] & "</font color>" = Yes

    I'm looking to have the CMS-HCC V22? in red if it says no and green if it says yes

    ------------------------------
    Alexis
    ------------------------------


  • 2.  RE: Color Fields

    Posted 23 days ago
    try this

    IF(
    [2020 Chronic Vs Acute Status]="Yes",
    <font color=red>" & [2020 Chronic Vs Acute Status] & "</font color>",
    [2020 Chronic Vs Acute Status]="No",
    <font color=green>" & [2020 Chronic Vs Acute Status] & "</font color>", [2020 Chronic Vs Acute Status])



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Color Fields

    Posted 23 days ago
    I tried it and it does not like field 2020 Chronic Vs Acute Status. 

    Should I be in the actual field? The Field is originally supposed to multiple choice but I changed it to rich text


    ------------------------------
    ALEXIS DALY
    ------------------------------



  • 4.  RE: Color Fields

    Posted 23 days ago
    You need to have to have two different fields.

    One will be the Multiple choice field wiht the choices of Yes and No.

    The other field will be a Rich text formula field which will add color formatting to those words.  The editing will be done on the plain multiple choice field.  So you will use the pretty fields on View mode on the form and in reports.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------