1 Reply Latest reply on Aug 31, 2014 4:45 PM by philmodjunk

    Conditional color change of field label possible?

    AlwaysHopeful

      Title

      Conditional color change of field label possible?

      Post

           Using Filemaker Pro v.13.

           I'm creating an interface for displaying whether or not our product is listed on certain sites (among other things, but this is the first snag I've run into).  The sites for now include Amazon, eBay, Website (this is our own site), also including "Other" for future possible sites where we may list in the future.

           Just as a visual, I would like the following color changes to happen (to the LABEL of the field) when when all (except "other"), some or none are checkmarked. Here are some screenshots to demonstrate...

           If ALL the sites (except OR including "Other") are CHECKED,  the STATUS Label should be GREEN...

      https://lh3.googleusercontent.com/cUjw55xfZOn5zDnZre2Py1OzbaDokHxhUSHWgt0GduWsLuoOOv7SDONJcASmtZMbA9Dl2KO5pPs=w1886-h735

           If ONLY some are checked, STATUS label should be YELLOW...(And, maybe when yellow, change the text "STATUS" to something darker (more readable against yellow). But, this is not that important.)

      https://lh5.googleusercontent.com/u_RgZXOZ2dN2Y64lV9GNmGw1EQ1npMzVOV4WOTVpigtRHeBDM4yRDnClkFDQWYgl5_Ff6SUA5ds=w1886-h735

           Finally, when NONE are checked the STATUS label should be RED...

      https://lh4.googleusercontent.com/bNGVF24iDdV_AjivaBx_p1ucKV1BFK8ieHEV16ghgKMW4ApuY6ECY2uFTp8gYNui7dGdjPVP0zo=w1886-h735

           ------------------------------

           In the Data \ Control Style \ Valuesfrom settings I added a "list" called WebsiteList (Amazon, eBay, Website, 'Allow Other')

           The field that I want to base the 'condition' on is called STATUS.

           I'm pretty new to this stuff, not sure exactly what to do next. I right-clicked the STATUS label and chose 'conditional formatting' but the condition "Value is" happens to be greyed out.

           Thanks for any help you can provide.

           ~Hopeful

        • 1. Re: Conditional color change of field label possible?
          philmodjunk

          The "value is" option is Greyed out because layout text like your field label does not have a value. You'll need to use the formula option to create a calculation that checks the values in the checkbox field. I recommend that you research the filterValues function. Here's an example: not IsEmpty (FilterValues (yourtable::checkboxfield ; "Apple" )) will be true if the check box for "Apple" is selected.