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. ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendmaybe this?
If([Send Letter]=false, "<div style=\"color:white;
adding a closing " after the last div?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
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
------------------------------This is a formula-rich text field to get a different field to turn red if it isn't checked. It will work on the formula field when it's on a form, but it won't work in the Send Letter field anywhere. I have a table on the dashboard that has the checkbox field on it and I want that field to turn red if false. I followed the directions word for word on a Quickbase article about it and it's not working.
It would just be normal if true.
------------------------------
Hannah Engelson
------------------------------
