Duration formula plus an icon

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I have a field that calculates today - another date. I want to use a red icon to "flag" if the other date is before today. I'm using Today()- Renewal Date to calculate if the renewal date has passed. I can't find a solution anywhere with any type of formula field.
Photo of Steve

Steve

  • 190 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Hi Steve

I have a video that shows how to use a Rich Text Formula field to include icons in your fields.

You'll just need to set it up using an If instead of Case formula. Something like this:

If([Renwal Date]<Today(),"<img src=\"https://images.quickbase.com/si/24/233-rhomb_red.png\">","")

-Sharon


(Edited)
Photo of Steve

Steve

  • 190 Points 100 badge 2x thumb
The first option worked like a champ. I don't know what I did wrong as I tried several variations of that formula, including those shown in the video, but nothing worked until now. Thanks again.