Web Development

Ask something
Discussion Locked

Lotus Notes Developement question

0 helpful
1 reply

by basir_noutash

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Greetings,

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)

Thanks

1 reply

by d.f.a.

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.

This discussion is closed to new replies.