Paint Database Field Depending on Data Entry

[it.bugarski]

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

[Lee Smith]

Why aren't you using Conditional Formatting?

Do you really want your end user changing the colors?

[it.bugarski]

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

[comment]

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

[it.bugarski]

Thanks, this seems to work !