Ask the Expert

Send message to users with documents in progress

I have a status field with 2 options either In Progress or Signed off. I would like a formula which calculates if a document is still In Progress after 28 days, then the user should be presented with a message, and should be presented with a message every 28 days until the Status = Signed Off.


Sounds like you need a scheduled agent. The agent can run against all documents whose ( progressStatus ? Today > 28 ) or some variation of that. I would suggest using LotusScript and creating NotesDateTime objects from the field that determines the Status Date and also create a NotesDateTime object from the Today function. Having these object will allow you to compare them arithmetically. Then you can simply create a new document, give it the appropriate fields, like FORM="memo", SUBJECT="The subject of the memo", BODY="The body of the memo". Then you can send it using the NotesDocument.Send(false,recipients) method.


This was first published in November 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: