« FileMaker Pro 15.0.3 … | Home | FileMaker DevCon 2017… »

Field Colors in FileMaker via other field and Xojo app

There was a question on how set field background color in FileMaker based on a color in another field:

So we define a field which gets a color using formatting rules. The other field defines the hex color code to use. To keep it smaller, we only allow 4096 colors: Those where the two digits per color channel are equal. So from 000000 to FFFFFF with steps of 11. e.g. put FF0000 here to make field background red.

To generate the conditional formatting rules, we use a Xojo app:

The workflow is like this:
  1. Cut or copy a field in layout mode in FileMaker.
  2. Go in the app and type the right field name for the condition.
  3. Press the button to add formatting rules.
  4. Paste field in layout with colors.
Please try it. To change/build the Xojo app, please download Xojo on the Xojo website. For just running the project with your custom modifications in the IDE, you won't need to buy a license.

Download test database and project here: FieldColor.zip
19 01 17 - 11:21