A Question of Color

[Jared867]

Hello,

I am not sure how to word this question so let me try to describe what I have and what I want to do.

I have a field in my database that has 2 values in a value list. They are "Verified" and "Not Verified"

What I woudl like to do, when in table view is to be able to have that when "Verified" is the selected value for that field, the field background will be yellow. If the field value is "Not Verified" Id like to field value to just remain white.

Now I know I can change the background/fill color of the field as a whole but that would make the field always the same color regardless of what value is chosen.

Is this possible? Seems like with as powerful as FM is, it should be. And if it is how possible, how would I go about doing it?

Thank You, Jared

[Søren Dyhr]

Indeed you can, eventhough you version doesn't support condtional formatting:

Here is a calc i use in a quoteline, which bases itself on the related unstored values on-hand and what could be produced with the raw material we already have stored.

Let(theString=Substitute(10^25-1;"9";"g");



Case(

ItemCount> Items::ItemOnHand+Items::ItemsWeCanProduce;theString;

ItemCount  > Items::ItemOnHand;TextColor ( theString ; RGB ( 240 ; 240 ; 10 ) )))

The way it works is that it's a mergefield in the webdings font, the colour is set to red default. What happens is when an order easily can be done will the mergefield be of no lenght, but when the on-hand level is exeeded does it turn the webdings into a yellow bar underneath text fields which are made transparent, if the pull attempted get way beyond what's on hand plus what we can produce is the bar turned red.

What is left is to tinker a little with the font-size and perhaps the 25 times to repeat the "g" in the beginning of the calc to make it fit the environment it should be shown in.

--sd