Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Field background color by calculated RGB value

Featured Replies

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

  • Author

Anybody?

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

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

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

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

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

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

Important Information

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

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.