Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Field background color by calculated RGB value


This topic is 4868 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

post-94185-0-50604400-1313162340_thumb.p

Posted

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

Posted

"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.

post-94185-0-84432800-1313188384_thumb.p

post-94185-0-96193800-1313188419_thumb.p

Posted

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...

Posted

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. :^)

This topic is 4868 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.