Forum Discussion

edcooper's avatar
edcooper
Qrew Assistant Captain
7 years ago

Boolean

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!
  • edcooper's avatar
    edcooper
    Qrew Assistant Captain
    I tried that and it gave me an error "column 0 expecting text
  • edcooper's avatar
    edcooper
    Qrew Assistant Captain
    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's avatar
    edcooper
    Qrew Assistant Captain
    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.