August 12, 201114 yr 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.
August 12, 201114 yr This is perhaps old school, but I would have a global container field under transparent data fields that fills by calculation.
August 12, 201114 yr Author "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.
August 12, 201114 yr 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...
August 13, 201114 yr 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. :^)
Create an account or sign in to comment