Web Development

General discussion


Lotus Notes Developement question

By Basir_Noutash ·

Is there any way to refresh specific fields only?
Actually I have two fields one Date/Time Editable named "Expire_Date" which is the expiry date of an equipment. And another computed field named Status. Now I want the Status field display "Expired" if the Date/Time field is passed from now. I used the follwoing formual in the Status field however it does not update automatically.

mVar := @Today;
nVar := @If(Expire_Date < mVar ; "License Expired" ; Expire_Date = mVar ; "License Expires Today" ; Expire_Date > mVar ; "License is still Valid" ; " Invalid Expiration Date or Never Expires");
oVar := @Text(Expire_Date);
@If(oVar = "" ; "License Never Expires or Invalid Expiration Date" ; nVar)


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by D.F.A. In reply to Lotus Notes Developement ...

The Status field must be a "computed" field. But this only re-computes when the document is refreshed/saved.

Other wise make it a "computed for display". But the status is not saved in the document which is important for views! So add the same formula to a view column.

A daily Agent might be required to update the status if it is permanently to be kept in the document.

Related Discussions

Related Forums