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.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
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.