A Lotus Notes approval reminder agent

The agent below reminds recipients of a Lotus Notes document that it is past due for their approval.

 REM "Send reminder of new 
requests to the Approver"; REM 
"Schedule is daily, not on weekends";

SELECT Form = "OSR2" 
& cDocStatus = "New";

REM "Initialize and increment Reminder counter"; 
jnReminders := @If(@IsAvailable(nReminders); 
nReminders + 1; 1) ; FIELD nReminders := 
jnReminders ;

REM "Write doc history";
jcDocHistory := "Reminder #" + @
Trim(@Text(jnReminders)) +
     " of Office Supply Requisition emailed to " +
      @Name([Abbreviate];cApprover) +
     " on " + @Text(@Now;"S2") ;
@SetField("cDocHistory"; 
cDocHistory : jcDocHistory) ;

REM "Add agent tracking fields." ;
FIELD dNotified := dNotified ;
@SetField("dNotified";
           @If(dNotified = ""; @Now; dNotified  : 
@Now)); FIELD cLastAgent := cLastAgent ; 
jcLastAgent := "Remind Approver" ; 
@SetField("cLastAgent"; 
@If(cLastAgent = ""; jcLastAgent;
   cLastAgent  : jcLastAgent));

REM "Email reminder";
jcSendTo :=@Name([Abbreviate]; cApprover); 
jcCC := "" ; REM "For testing, add a blind carbon copy" ;
 jcBCC := ""; jcSubject := "Reminder: Requisition for "  
+ cAssociate ; jcBody := 
"You have not responded to the Requisition for "  +
  cAssociate + ". 
Click the doclink at the bottom of this message!" ;

@MailSend(jcSendTo; jcCC; jcBCC; jcSubject; jcBody;
           ""; [IncludeDoclink])

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Stevenson Campbell. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Download this free guide

Download: IT Certifications 101

Inside this exclusive essential guide, our independent experts break down which IT certifications are worth your time and effort, and how to get started obtaining them to further your career— including specific certifications that any cloud or desktop pro should seriously consider.

Start Download

• Corporate E-mail Address:

  You forgot to provide an Email Address.

  This email address doesn’t appear to be valid.

  This email address is already registered. Please login.

  You have exceeded the maximum character limit.

  Please provide a Corporate E-mail Address.

• • I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

  Please check the box if you want to proceed.

• • I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.

  Please check the box if you want to proceed.

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.