Skip to main content
Question

Dynamic rule setting for rich text field

  • June 30, 2020
  • 0 replies
  • 41 views
Hi Quick Base Community! I'm trying to set up a dynamic rule for the following condition:

When [Status] equals to "Renew", show [Has a renewal audit been scheduled?]

[Status] is a formula rich text field and has the following formula:
If(([When does the accreditation expire?]<Today()),"<div style=\"background-color:red;width:10\">Expired</div>", ToDays([When does the accreditation expire?]-Today())<=90,"<div style=\"background-color:yellow;width:10\">Renew</div>", ToDays([When does the accreditation expire?]-Today())>90,"<div style=\"background-color:lightgreen;width:10\">OK</div>")

The rich text formula field doesn't seem to work in dynamic rule. Appreciate if someone can shine some lights on this. Thanks!


------------------------------
Joanne Wong
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
I suggest making a status field in plain text and then a separate formula field to display that as Rich Text.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • June 30, 2020
Hi Joanne,

The issue you are running into is probably because as a formula rich text field it doesn't have just a text value in the field to match against. Have you tried setting it so when Status is equal to ""<div style=\"background-color:yellow;width:10\">Renew</div>"" and including the full way you are styling the text for the check? 

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Terms & ConditionsAccessibility statement