Skip to main content
Question

Display a message using a formula rich text field

  • July 10, 2023
  • 0 replies
  • 472 views

Hello,

I am trying to use a formula rich text field to display a message. Has anyone had success in doing so? 

For instance, I want to display a note saying "Only the 1st DO is shown. To see the additional DO, open the Agreement." I then need to apply a Field Condition so the note only shows if a specific field is checked.

Thanks!



------------------------------
Colin Fox
------------------------------
    This topic has been closed for replies.

    • Gary1
    • Quickbase Alumni
    • July 10, 2023

    Unless I'm misunderstanding the question, this should do the trick in a rich text formula field:

    If([checkbox],
"Only the 1st DO is shown. To see the additional DO, open the Agreement.")


    ------------------------------
    gary
    ------------------------------
    gary
    • JustinBiggers
    • Quickbase Alumni
    • July 11, 2023

    If you want to add color use 

    If([checkbox]=true,"<font color=red><b>Only the 1st DO is shown. To see the additional DO, open the Agreement.</b></font>", 

    If([checkbox]=false,"<font color=green><b>More Text Here</b></font>"))



    ------------------------------
    Justin Biggers
    ------------------------------
    Terms & ConditionsAccessibility statement