Skip to main content
Question

Boolean

  • June 30, 2018
  • 0 replies
  • 93 views
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!
    This topic has been closed for replies.

    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.
    • edcooper
    • Author
    • Registered
    • June 30, 2018
    I tried that and it gave me an error "column 0 expecting text
    • edcooper
    • Author
    • Registered
    • June 30, 2018
    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.
    • edcooper
    • Author
    • Registered
    • June 30, 2018
    It works. Thanks!!
    • edcooper
    • Author
    • Registered
    • June 30, 2018
    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.
    Terms & ConditionsAccessibility statement