Discussions

Expand all | Collapse all

Changing a formula numeric field's return color.

  • 1.  Changing a formula numeric field's return color.

    Posted 04-11-2018 16:47

    Hi i am very new to Quickbase.  I have a field that i created that shows the number of days since the first contact date to a potential independent contractor that we want to work for us.  I want that numeric field to return not only the number of days since the first contact with the "IC" but if the time period is over 30 days i want that number to appear red.  Can someone guide me in the right direction?


  • 2.  RE: Changing a formula numeric field's return color.

    Posted 06-18-2018 14:55
    In case you have not found the answer. make a Rich Text Formula field with the following but replace the [First Contact Date] with the field that you are using to track the contact date.
    "<div style='color:#ff0000'>" &ToDays(Today()-[First Contact Date])& "<div>