[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Notifications when a document is modified

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
Z_Beeblebrox
Asked:
Z_Beeblebrox
  • 3
1 Solution
 
MWCommented:
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
 
Z_BeeblebroxAuthor Commented:
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
 
MWCommented:
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
 
ikke_de_steveCommented:
just put an @mailsend in the querysave.

No evironment variables, no test

just send mail.

Good luck
Ikke De Steve
0
 
MWCommented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now