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

Paint Database Field Depending on Data Entry

Featured Replies

There is a text field Status and Drop Down List with different Statuses - High, Normal, Low.

The idea is that when we change status in drop down list then to change and color of entire field.

So, when Status is High then to be Blue, when Normal then Green and for Low to be in Red.

No, cant use conditional script because end user might want to change and relate High to Yellow etc.

Right now I use TextColor(UNDERLINES;RGB( Red ; Green ; Blue ))

Which retrieve underline in different colors but that that is not good enough as it leaves white margins.

Indeed, is possible anyway to set field in different color via script?

Best Regards

Why aren't you using Conditional Formatting?

Do you really want your end user changing the colors?

  • Author

Thanks for quick reply as first.

Unfortunately yes, it has to be done this way, through the script.

Conditional Formatting is cool but too narrow option in some cases.

For example in simple HTML we can set background color of database field by simple command.

So I'm surprised that in FileMaker we cant use something easy to do the same.

Might be good idea to bring that functionality in FileMaker 13...

Right now I use TextColor(UNDERLINES;RGB( Red ; Green ; Blue ))

Which retrieve underline in different colors but that that is not good enough as it leaves white margins.

Try =

TextColor ( TextFont (  TextSize ( "g" ; 1000 ) ; "Webdings" ) ; RGB ( Red ; Green ; Blue ) )

  • Author

Thanks, this seems to work !

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.