Expand all | Collapse all


  • 1.  Boolean

    Posted 06-29-2018 22:38
    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.


  • 2.  RE: Boolean

    Posted 06-29-2018 22:47
    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)


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

    I like to comment the colours as then I know what they are in english.

  • 3.  RE: Boolean

    Posted 06-30-2018 00:22
    I tried that and it gave me an error "column 0 expecting text

  • 4.  RE: Boolean

    Posted 06-30-2018 00:25
    The field being a checkbox....does it require a boolean in the formula?

  • 5.  RE: Boolean

    Posted 06-30-2018 01:02
    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.

  • 6.  RE: Boolean

    Posted 06-30-2018 01:13
    It works. Thanks!!

  • 7.  RE: Boolean

    Posted 06-30-2018 03:21
    I'd like to have a multiple choice field with checkboxes instead of a dropdown. Possible?

  • 8.  RE: Boolean

    Posted 06-30-2018 12:15
    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.