Hi,

I'm trying to learn how to set color attributes in value lists. I have a field called "Actions" that uses a 5 item list: (Out, Resend, Accept, Revise, Withdraw).

Right now I'm setting text attributes manually. I'd like to know if I can auto-format the color of the value list items. Via a calculation?

Note: I'm not a total newbie but I still have a very limited understanding of calculation and summary fields. I can't seem to follow the syntax...

You can have your list in other table with colors.

And by script open this table and choose necessary value. I attached example.

ColorValList.zip

Hi AAA,

Not sure I get it entirely yet. I think I need to play around with your example, but it is helpful, and so thank you. I may have more questions.... :)

Another option would be to make the field an auto-enter calc that refers to itself. Try something like:

Case ( field = "A" ; TextColor ( field ; RGB ( 255 ; 0 ; 0 ));



field = "B" ; TextColor ( field ; RGB ( 0 ; 255 ; 0 )) ;



field = "C" ; TextColor ( field ; RGB ( 0 ; 0 ; 255 ))



 )

Make sure that "Do not replace existing ..." is NOT checked for it to update properly.

Hi Kent,

This seems like the right solution but I don't understand how the syntax works. I have only one field, called "Actions". Would I place it in "A", "B", "C" regardless?

PS Can either of you recommend a good tutorial on calculation fields? I just don't understand them yet, and there don't seem to books that provide a sufficient explanation. Thanks.

Edited November 25, 200520 yr by Guest

Here's an example of an auto-enter calc that colors the text in the field. See if it makes sense to you.

I think you may also want to color the text in the value list display itself, but I don't believe that's possible. You might want to check in the "Plug-ins" section of this forum to see if anyone's written a plug-in for this.

Good references for learning calculations (and a lot of other good FileMaker related stuff) are:

Using FileMaker 7, Special Edition, ISBN 0-7897-3028-6

FileMaker 7 Bible

Database Pros' website.

A FileMaker Affliction website

FM Forums! :chili:

ColoredText.zip

Hi Kent,

Yes, even though I am a programming incompetent I do get the syntax this time! I haven't tried it yet, but I feel certain I can do it. What's more it is elegant (a nice thing for a poet)! Thanks a bunch. You've helped someone be more productive in life. Next time you're in the Toronto area I shall buy you lunch if you so wish...

Charles

P.S. It works!! Thanks again!

Edited November 26, 200520 yr by Guest