Discussions

 View Only
  • 1.  Adding a conditional text color to a numeric formula field.

    Posted 08-02-2020 10:42
    Hello,

    I've rather new, and have searched but cannot seem to find the right combination to colorize the text of a numeric formula filed if selections are made in another field.  We are generating an Authorization Number based on the selection of [Authorization Type].

    Here is the formula I'm using, I just want to add a color to each selection.  For instance if the selection is "PPO Approved" I'd like the color to be green, "Out of Network Approved", red.  Down the line I may also want to add additional colors to other selections.

    Case([Authorization Type], "PPO Approved", [Record ID#]+60078965, "Out of Network Approved", [Record ID#]+70078965, null)​

    Hope that makes sense.

    Thank you in advance.  I'm probably missing something rather simple.



    ------------------------------
    Chris Hesenflow
    ------------------------------


  • 2.  RE: Adding a conditional text color to a numeric formula field.

    Posted 08-02-2020 11:42
    You will need to create a new formula Rich Text field  to do this.  Here is some help text.
    https://help.quickbase.com/user-assistance/color_field.html


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



  • 3.  RE: Adding a conditional text color to a numeric formula field.

    Posted 08-02-2020 12:14

    Thank you for the reply.

    ------------------------------
    Chris Hesenflow
    ------------------------------