Skip to main content
Question

formula assistance - rich text w/date

  • June 2, 2022
  • 0 replies
  • 27 views

Forum|alt.badge.img+11
[SAND DATE STATUS]
IF THE DATE IN [SAND DATE] FIELD IS "before today", display red status button, otherwise display blue button.

IF(ToText([SAND DATE])<(today)),
"<img src=\"https://images.quickbase.com/si/24/204-warning.png\" title=\"delete\">",
"<img src=\"https://images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\">")



------------------------------
BuildPro
------------------------------

Forum|alt.badge.img+11
  • Author
  • Registered
  • June 2, 2022
CORRECTION...
DISPLAY "WARNING BUTTON"...NOT RED BUTTON

------------------------------
BuildPro
------------------------------