Field Color Fill - Conditionally

[snackcakes101]

Hi! Is it possible to set up a script (in a table view) to say something like, "If x field = "no", fill color = x"? I want to be flagged when an authorization is not signed by changing the field fill color. Or at least the text color. Am I nuts? (That is debatable, I'm sure)

[andygaunt]

What you can do is have a global container that holds a colour. (lets call it gColor

Then create a calculation field (result of container), with storage options set to do not store calculated result.

If x field = "no, gColor, "")

Now, on your layout, place this field behind your field you wish to color or flag. Make sure that the fill color on the field in front is transparent.

Then if the condition is met, the color appears, otherwise it doesn't

HTH

[Ugo DI LUCA]

I was looking for that tip to.

Now, probably most simple, how can we change the text color if the result is negative?

[harryk]

>change text color if negative

Field Format Number...

Harryk

[Ugo DI LUCA]

Sorry, I meant conditionally.

For example

If order not sent, coler Order N

[CobaltSky]

This can be done by creating a calculating field which references the source field based on the condition you specify. For example:

Case(OrderStatus = "Not Sent", OrderN

[Ugo DI LUCA]

Not enough stars proposed. Great job