Listbox: “Blank if null” for TIME Columns and Footers!

For many versions, the “Blank if null” property has been available for “time” type zones, whether for input or display. However, it was not previously available for columns or footers of this type in listboxes. With 4D 20 R7, this limitation has been removed!

Property list

The “Blank if null” property is now accessible in the display theme and is available for both columns and footers.

Programmation

Whether it’s a column or a footer, you can define the display behaviour by programming:

// using a pattern string (20 R4 and above)
OBJECT SET FORMAT(*; "colTime"; "HH:mm:ss blankIfNull")
// legacy mode
OBJECT SET FORMAT(*; "colTime"; Char(System time short+Blank if null time))

Common Result

Without blank if null  |  With blank if null

Conclusion

A simple check box (or a simple line of code) makes the results clearer and more intuitive, right?

Let us know what you think on the forum! We value your feedback and look forward to hearing your thoughts on this new feature.