Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Need help with and agent for auto email based on date in form.

Posted on 2003-03-20
Medium Priority
Last Modified: 2013-12-18
The form name is problem, the field name is holduntildate. I want the system to send a standard email with a form link to the author (also a field name on the same form)when the holduntildate matches today's date.

Please be descriptive as I am a true newbie to Lotus notes! I've never run an agent and I don't know code.
Question by:aeonflux2
  • 2

Expert Comment

ID: 8177292
Create a view with a selection formula such as the following:

SELECT Form = "problem" & holduntildate = @Today

Then create an agent, set it to run on all documents in the database, and then in the agent's Search Builder window, add the additional criteria that the documents must appear in the view that you just created. Then, in your agent, add some formula such as this:

@MailSend(author; ""; ""; "Subject"; "Remark"; ""; [IncludeDocLink])



Author Comment

ID: 8183919
The view is not pulling any of the problem forms with a hold date of today.

Accepted Solution

scottrma earned 500 total points
ID: 8184668
Look at the document properties box for any one of your documents that should be appearing in the view. Check your field "holduntildate". What is the datatype? Is it Time/Date, Text, or something else? If it is Text, then you would need a selection formula like

SELECT Form = "problem" & holduntildate = @Text(@Today)

Also, is your form name really "problem"? Or is it "Problem" or "PROBLEM" or "PrObLeM"? You may want to try something like

SELECT @LowerCase(Form) = "problem" & holduntildate = @Today



Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

564 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