change format of field

Applications Grid / Reports
#1

Hi is there any way that I can change the format (or even better, display an image) of a field when the value is blank?
say for instance that I want to show the value (text) from the database but when there is no value I want to show an alert icon.
otherwise if I can replace the 'blank" with a warning text in different colour that would work as well

thanks

#2

Not sure if this will work for you but you can apply (label) fields containing your alert and set the visibility to on or off depending on the value of some other field.

#3

thanks, I have created the label field now. how can I set up the visibility on or off depending on the other field ?

#4

[TABLE=“class: table_macro, cellpadding: 5, cellspacing: 0”]
[TR]
[TD=“class: macros, width: 20%”] [LEFT]sc_field_display ({My_Field}, on/off)[/LEFT]
[/TD]
[TD=“class: macros, width: 27%”]This macro dynamically display or not a specific field.[/TD]
[/TR]
[/TABLE]

See the manual…