Syntax Error

Question

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, "&lt;div style=\"color:white;background-color:red;\"&gt; false&lt;/div&gt;, [Send letter] )

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

markshnier__you · Answer

maybe this?

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

adding a closing " after the last div?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

hannahengelson · Answer

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 · Answer

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
------------------------------

hannahengelson · Answer

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------------------------------

markshnier__you · Answer

I think there may be some confusion here between how Excel works and how QuickBase works.&nbsp;

In Excel you can have what is called conditional formatting, which will color the field. But in Quickbase you cannot do that. So this would be a completely separate field, and it would be a formula fieldnot an entry field. &nbsp;Not an entry field. &nbsp;&nbsp;

because you checkbox field called send letter is a checkbox type field, you cannot have that be the calculated result if a Rich Text field.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Syntax Error

7 Replies

Related Content

email notification error

Incompatible value error

Error Report

Jinja If else statement syntax

Syntax Error

Recent Discussions

Formula URL - Edit then Add

Share your feedback on the new Qrew Discussions

Date value changes when copied to new table with pipeline.

Pushing JSON data to external API endpoint

Create and edit child and grandchildern from within a parent form help please