Forum Discussion

35532's avatar
35532
Qrew Member
3 years ago

Formula: Color Coding and Dates

Hello All! I am new to Quickbase and I am having trouble finding out how to code. I need to make a report that tracks all employees and how long they have worked at my company. I have the basic inform...
Formulas and functions
35532's avatar
35532
Qrew Member
3 years ago
Thank you! Do you know if there is a way to color code the numbers in a field? For example, an employee has worked for 5-10 years the field would be green, etc.
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    Just want to colour a single field it's a little more complicated than XL. You're actually need to create a formula rich text field and use a formula as described here.  

    https://help.quickbase.com/user-assistance/color-coding_fields.html

    Here is another example

    Background Shading
    var text ColorCode =

    If(

    [Delivery Date]-Today()<Days(1),"pink",

    [Delivery Date]-Today()<Days(3),"yellow",

    [Delivery Date]-Today()<Days(5),"green");

    var text DateText = ToText([Delivery Date]);

    Case($ColorCode,

    "pink","<div style=\"background-color: pink;\"" & ">" & $DateText & "</div>",

    "yellow","<div style=\"background-color: yellow;\"" & ">" & $DateText & "</div>",

    "green","<div style=\"background-color: #00C957;\"" & ">" & $DateText & "</div>", $DateText)



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------