Field background color by calculated RGB value

[Don_Macaroni]

I'm breaking my brains here, I must be over thinking this... I have a Repeating field (3) in which I enter the R, G and B value of an RGB color for use with Filemaker code:

RGB ( red ; green ; blue )

The color it generates I want to be able to use for, for example, field backgrounds. Is this possible at all? It must be...

Conditional formatting only allows the designer to pick the color, not the end user of the database.

[Don_Macaroni]

Anybody?

[bcooney]

This is perhaps old school, but I would have a global container field under transparent data fields that fills by calculation.

[Don_Macaroni]

"that fills by calculation" with Conditional formatting? But would a user be able to fill in HEX or RGB values?

I came up with a webviewer solution and a 1KB custom html file with javascript... Had to replace RGB with HEX, but looks pretty slick and works nice. Only down fall is that Web Viewer is always on top (correct me if I'm wrong).

Check attachment...

By the way, header is completely dynamic and can be manipulated by end users. Header image and transparent tabs.

[comment]

You could use a calculation field with a Text result. Text can be colored dynamically using the TextColor() function. Try the g character in Webding font and a huge font size.

BTW, giving users the option to design the look of your solution is one way to guarantee it'll be ugly...

[LaRetta]

BTW, giving users the option to design the look of your solution is one way to guarantee it'll be ugly...

It is also a way to cause an entire business to go to war with each other; been there, done it. :^)