The biggest limitation is being able to format based on a secondary feild.
There is no such limitation. Change the default [Value is] selection to [Formula is] and enter your calculation, refering to any field/s you need.
IS there a way to script from within a calulation an objects color?
Not quite sure what you mean here.
after one enters a HSV value codes they are altered upon closing the menu to 'another set of numbers';
Filemaker uses RGB as its color space. If you use the OS color picker, the chosen color must be converted to RGB values before Filemaker can accept it. This, I believe, is done by the OS rather than by the Filemaker application itself. Different color spaces do not translate one-to-one, so you may not see the exact same values the next time you open the color picker.
Gee so I was being utterly dense! It never dawned on me that Formula Is could have been a point at which to INSERT FORMULA LINE HERE line to referance a secondary feild. Some one PLEASE get the (Warner Brothers) ACME mallet and pound me one for being stupid.
I will go back to also retry the RGB functuon agian.
Goes back to try again...