Boolean

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • Answered
Driving myself crazy.
I have a field in a form called RED FLAG which is a checkbox type.
I want to colorize the record in a report view to 'Crimson' IF the field is checked.

I have tried using toBoolean but just can't get the formula right.

HELP!
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Try this

IF([RED FLAG],"red")

except that red is so strong that you cannot read the words.

So in use Laura's tool here to choose a hex code colour. (Laura is another great QSP)

https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1

IF([RED FLAG], "#FF82AB") // pink

I like to comment the colours as then I know what they are in english.
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb
I tried that and it gave me an error "column 0 expecting text
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb
The field being a checkbox....does it require a boolean in the formula?
A checkbox field is a boolean.  When you save the report and then  reopen it, does it give you a syntax error on the row colorization formula?  The messages which show up when you are editing the formula in the box are not always reliable.
(Edited)
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb
It works. Thanks!!
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb
I'd like to have a multiple choice field with checkboxes instead of a dropdown. Possible?
Do you mean a multi select field type where the user can select say all the different fruit they like?

If so use a multi select field type.