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,
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
------------------------------
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
------------------------------
------------------------------
Joanne Wong
------------------------------