If you want to dynamically set the r, g and b values for a field's fill color, this cannot be done.
You can set up a series of conditional value list expressions such as:
$$color = Red
$$Color = Orange
$$Color = Blue
and so forth, each row here is a different conditional format expression and you can specify a different fill color for each row.
Then, to change the color, you need only change the value of $$Color. You could also use a global field formatted with a drop down list of color names in place of $$Color.
Thanks Phil, That seems like it may work based on just a few sets of colors. I currently have over 2000 records in a database to choose a specific color. What I would like to have happen is when my customer chooses a single record, the RGB values of that color (all in there own specific fields) within that record will display a color on their screen. The field showing the color would actually have no data associated with it (so maybe a 'container'. Again, i'm new and just learning so I don't even know yet how or why you'd use a container')
why you can change the 'text' color of a field, but not the field color fill itself seems odd.
thanks for your help
I understood that you wanted to specify RGB colors, but it isn't something that you can do using a built in capability of FileMaker. You'd have to construct your own methods for doing that and setting things up for that could be vary labor intensive.
You could, for example, set up a related table where a container field stores a rectangle with a specific color. 3 Number fields for the r, g and b values could be added and used in a relationshp to link a given record to it by rgb values. But you are talking about a huge table with a tremendous number of records to cover the possible range of RGB values you might want to specifiy.
"The field showing the color would actually have no data associated with it (so maybe a 'container'. "
No, not a container, but a simple web viewer !
I guess for the time being I'll just modify the color of the text.. Maybe FM will give us the option to change the field color in future rev's.
thanksa again for your help.
What does prevent you from using a simple Web Viewer instead of a field?
Could you post an example of how you'd do this? I'm curious to see how you'd implement this. It sounds like an excellent solution.
where FieldColor::RGB contains something like: rgb(255, 0, 0)
( this code could be improved for the known problem of the WV's borders in windows )