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 last published in November 2001

Dig Deeper on Domino Resources - Part 4

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



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:




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...