Nag Mail Revisited

Posted on 2005-04-28
Last Modified: 2013-12-18
I use 3 Forms in my system (see listed below)

[Request Form] = User creates a document (Parent Document)
                     options on Form = There is a Field called [NagMail] (Yes/No)
                                                There is a Field called [DueDate] Date Field
If the users checks Yes in NagMail the DueDate Field displays and they can set the date they want  responses back by.

[Outgoing Request Form] = Basically all the same fields as form 1 only computed values(shows up in Inbox)
                     options on Form  = There is a [Replay Action] and a [Forward Action]
                                                 Reply Action Composes [Response Form]
                                                 Forward Action Creates a new SendTo and resends the [Outgoing Request Form]
[Response Form] = The Form used to allow the user to respond to the [Request Form].  It is also a response document and the comments as well a link to the document is placed in the parent document.

Here is what I need to be able to do --

If the user wants to use the NagMail the people in the [SendTo] field has unitl the [DueDate] to respond.  If by Midnight the DueDate they have not repsonded - they should get a email everyday stating they need to respond.  I know this will require a agent and somehow list all the people needing to repsond still.

I had posted a previous thread about this, but got busy on other stuff and could not address it.   I wanted to start clean with a new question.  My script skills are coming up to speed, but I still have some issues, so any code you can share the better for me.
Question by:Jaziar

    Author Comment

    Not one response :(
    LVL 46

    Accepted Solution

    This question is too complex I think. There are too many things to keep in mind, which makes me wonder about the design. If you're analysing and designing "on-the-fly" (I mean while developing) and the application gets as complex as you describe, you'd better have a lot of experience in application development. The only other solution is to write down what you want, and see to it that the description goes to a detail that the average developer would understand. If things get difficult, then pay more attention to the analysis or design, whichever phase you're in.

    How does this help you? Not at all? If you could write your text above in some sort of pseudo-code, you'd have the solution almost immediately. Now where to start? You already know you need an agent. Describe the process of the agent in simple If-Then-Else, and other constructs you can think of. Describe the prerequisites for the agent, the document-fields and the environment required, in a very organized way, almost to explain yourself what's the goal.

    I have:
    - field1
    - field2

    I want:
    - etc

    Hope this helps...


    Author Comment

    Thanks for the suggestion - I will try to organize it better

    Author Comment

    Defined:  I want the user to be able to turn on nag mail.  when the user creates a document they can choose if they need responses or not and by a certain date.  I may need to get data from 3 differnt people for a meeting on May 5.  so when I create the request -- I can select nagmail on and pick a date of May 4.  If the users dont reply to me by that date it will send them a email everyday telling them to respond to the request.  

    I have 3 fields
    Field Name = [NagMail] (Check Box) Do you want to turn on Nag Mail on this document? Yes/No

    If the selection is Yes then the second field appears
    Field Name = [DueDate] (Date) This is just a date field - This allows the requestor to be able to set a date for replies.
    Then there is field 3
    Field Name = [NagList] (hidden, computed field)  I am using this code in a action when the emails are sent.

    If doc.NagMail(0) = "Yes" Then
          Set item = Doc.ReplaceItemValue("NagList", Doc.SendTo)
    End If

    All of above works and does not need to be worked on unless someone has a better idea.

    NagList is now populated with names of users - When that user replies to the request it needs to remove them from the field - see below

    eq:  [Naglist] has a value of Jaziar, Bob
    Bob replies - now [NagList] has a value of Jaziar

    The reply code the users click is on Form 3 which is a response document to the first request form 1.  I can cut and paste the code if needed.

    Here is my idea of what the agent will do

    Every evening at midnight the agent will start and check every document that is not a response document.

    Subject = "Your attention is required"
    Message = "Please click link below and respond to action"

    Is NagList != ""
       get current date
       get date from Field DueDate
       If Current Date is past DueDate
          send Email to everyone in NagList w/doclink
          do nothing
         do nothing

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    If no attachment, dont send email - lotus notes/vba 10 345
    Domino Server 11 54
    Lotus Domino server 9 7 57
    attaching a file lotus notes 4 95
    For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now