You need to create an agent that is a duplicate of the "Process Past Due Approvals" Agent and call it something like reminders. Modify the selection criteria that appears in the initialize object from:
Set documents = db.Search("@Today => @Date(DueDate) & @Member(Status; StatusList) = 3", Nothing, 0) to something like Set documents = db.Search("@Adjust(@Today;0; 0; -2; 0; 0; 0) => @Modiifed) & @Member(Status; StatusList) = 3", Nothing, 0)
This will select the documents that have not been modified in two days and are awaiting approval.
This will work in most cases but if someone edits and saves a document but doesn't approve it, a reminder will not be sent until two days after the edit. You can get around this by modifying the actions to save a last action date and use this in your selection formula.
Dig Deeper on Lotus Notes Domino Formula Language
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response. Continue Reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead. Continue Reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.