Re: Background or text color conditional

On Apr 24, 4:15 pm, Buckbuck <buck.matthe...@xxxxxxxxx> wrote:
FM 8.5

Is it possible to create a calculation whereby if the Status value
changes the field back ground or field text will change? I would like
to colour code a report to show "Paid" bills in red text or a gray
background.

Thanks for any answers or suggestions on how to design this.

Matthew

The easiest way would be to upgrade to 9. It's a new feature.

If you're sticking with 8.5, here's how I would do it.

Create a global container field. Set that field to display Reduce or
Enlarge, Centered, and Not Maintain Original Proportions.
In Layout Mode create a 10px x 10 px box using the rectangle tool.
Set its borders to 0 px. Set it's fill color to the color you want as
the field background you want.
Select the box, copy it, go to Browse mode and paste into the global
Container.

In the table with the Status value, create a calculation field with a
container result.
Set the calculation to whatever something like Case(Status = "Paid";
Global Field).
Place that field behind the Status field. Set the Status field to
transparent.

Voila, you've got your own highlight field.
.