Forum Discussion

VictoriaLaw's avatar
VictoriaLaw
Qrew Trainee
6 years ago

Formula - Rich Text code displaying on dynamic filter

Hello! I'm a beginner to QB. I've searched high and low in the community posts for a similar question and haven't come across any. I wrote a rich text formula to evaluate if a date is before or aft...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Right, so DFs will not render in HTML.  I suggest you make two fields.

The Status field would be formula text.

If([Term End] > Today(),"Active", "Inactive")

The [Status colored] field or perhaps named [Status.] if you want to be sneaky and have a short name for reports would be a Rich text formula field 

Case([Status],
"Active",   "<div style=\"color:green;\">Active</div>",
"Inactive", "<div style=\"color:gray;\">Inactive</div>")

The use the [Status] field as the DF and the [Status.] field on the report.


  • VictoriaLaw's avatar
    VictoriaLaw
    Qrew Trainee
    6 years ago
    This worked a treat and seems so simple now. Thanks for your help!