?
Solved

Notifications when a document is modified

Posted on 2000-03-08
5
Medium Priority
?
314 Views
Last Modified: 2013-12-18
Hi,

I am looking for a quick clean simple method of sending an e-mail notification anytime a document is modified. The caveat is that only one notification should be sent when the document is closed, so that if the user saves the document several times before closing it, only one notification is sent. I would also like to avoid using an agent to accomplish this if possible.

Thanks,

Zaphod.
0
Comment
Question by:Z_Beeblebrox
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 3

Accepted Solution

by:
MW earned 200 total points
ID: 2596591
1. create a subform

2. in the postopen event of the subform place following formula:

@Environment("DocHasBeenSaved";"0")

3. in the querysave event of the subform place the following formula:

@Environment("DocHasBeenSaved";"1")

4. in the queryclose event of the subform place following formula:

@If(@Environment("DocHasBeenSaved")="1";
@MailSend(sendTo;copyTo;blindCopyTo; subject;remark;bodyFields;[flags]);
"")

5. place the subform into the form where you would need this functionality
0
 
LVL 7

Author Comment

by:Z_Beeblebrox
ID: 2596740
Seems like it should work... I didn't even think about using environment variables. I will implement it and then test it and then give you the points assuming all goes well. One question though? Why do you say a subform is required? I could do everything on the form itself.

Zaphod.
0
 
LVL 3

Expert Comment

by:MW
ID: 2596786
I prefer using subforms not to be blocked using script in the events of the form.

But of course you can keep it simple placing the formulas into the form.
0
 

Expert Comment

by:ikke_de_steve
ID: 2603863
just put an @mailsend in the querysave.

No evironment variables, no test

just send mail.

Good luck
Ikke De Steve
0
 
LVL 3

Expert Comment

by:MW
ID: 2603902
just to put the command in the querysave won't do it. It will send a mail every time a user saves the document. It should send the email only once when closing the mail and only if the document was saved at least once.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

650 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