CODEWITHSUNDEEP
lotus-noteslotusscript
Reinhaa
Reinhaa

Reputation: 195

Set name of all empty field in view

I have a date/time field name DeliveryDate and I have a view that will list all Delivery date. Some of document will have empty delivery date. Below here the example of the view.

yerro

Right now, the view show "(Not Categorized)". How can I change it to another name such as "Old Record". Any help will be appreciated. Thanks!

Upvotes: 0

Views: 109

Answers (2)

Theo Heselmans
Theo Heselmans

Reputation: 181

The easiest thing to do is change the formula for that view column to e.g.:

@if(DeliveryDate=“”;”Old Record”;DeliveryDate)

Of course you might prefer to remove those records from the view all together. In that case just add the following to the Select formula for the view:

& !DeliveryDate=“”

Upvotes: 2

John_Curtis
John_Curtis

Reputation: 11

Without changing the data? You can't, today. To understand - you want different text instead of "Not Categorized" to represent empty data? And that would be at the view level?

Upvotes: 0

Related Questions