I have the movie database and first enter the title that should ALWAYS be entered.
For this I have a calculation field “title entered” below that queries this.
IFEMPTY (MOVIE TITLE; “NO, still missing …”; “YES, everything ok”)
This text color is red.
It should remain red if the “Title” field is empty or GREEN if the title is entered.
Can I change color of a field “title entered” with a formula or with an easier way?
Hi Wolfgang,
There’s no function to change the label colour from a Calculation field formula.
However you could do it from a Script field. And however again, changing the lableColour
property on the field will change it for all records though.
If you enable the Required Field
option on your field, then if a value is not provided, the field label will show in red automatically.