Boolean

  • 0
  • 1
  • Question
  • Updated 6 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

  • 880 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
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

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

ed cooper

  • 880 Points 500 badge 2x thumb
The field being a checkbox....does it require a boolean in the formula?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
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

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

ed cooper

  • 880 Points 500 badge 2x thumb
I'd like to have a multiple choice field with checkboxes instead of a dropdown. Possible?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
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.