Forum Discussion

HannahEngelson's avatar
HannahEngelson
Qrew Trainee
6 months ago

Syntax Error

I have the following code on a formula field to highlight a checkbox field if it's false. I copied this code directly from the Quickbase article about it so I cannot figure out why it wouldn't work. The first backslash highlighted below is the one producing the error. Please help!

If([Send Letter]=false, "<div style=\"color:white;background-color:red;\"> false</div>, [Send letter] )



------------------------------
Hannah Engelson
------------------------------

7 Replies

  • maybe this?

    If([Send Letter]=false, "<div style=\"color:white;background-color:red;\"> false</div>", [Send letter] )

    adding a closing " after the last div?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • HannahEngelson's avatar
      HannahEngelson
      Qrew Trainee

      Tried that and then I get an error on the second [Send Letter]. If I remove it, it doesn't work when tested.



      ------------------------------
      Hannah Engelson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        But what field type is this. It must be a rich text field, but if the condition is true, then you have a result being Boolean?  So that makes no sense.  What do you want the result to be if [Send Letter] is true?



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------