Dynamic rule setting for rich text field
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 t...
Forum Discussion
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
------------------------------
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
------------------------------
- Thanks Evan. I did but the dynamic rule is still not working.
------------------------------
Joanne Wong
------------------------------- Hi Joanne,
Yeah the form rules aren't really set to mesh with formula rich text fields as they pull in different values. They often function best as ways to stylize text over as a component of workflow. Another way to do this is to create a plain formula text field in the background that has the same formula but returns only text and have it hidden doing the work of running your form rule along side the stylized text.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------- Thanks Evan. Actually I tried it again and it worked! There was probably an error in the formula I put in. Thanks for your help!
------------------------------
Joanne Wong
------------------------------