Hi!
I’d like to change a copy from a discussion database in a way that every time a new entry was added to the database (new topic or response) a mail is send to all members of the ACL.
How can i do this with an absolute minimum of changing sripts or forms??? could i shedule a agent for this?
Experts! Please what is your advice?
Thanks
Subject: automatic mail after new entry in discussion DB
I can think of four places you can put the code - not sure if any one is especially better than the other without knowing more about your design (*).
A form level action button that saves the submitted doc and sends the email.
A form querysave event to send the mail.
A db agent ‘if new document is created or added’.
A scheduled agent that runs on new docs
(there may be other places in R6, we haven’t made the jump just yet).
If you only have one form, all choices are about the same (actually the form action may require a bit more thought).
If you have more than one form, you could create a subform with the action button or querysave code and add it to every form.
(*) - if you already have complex querysave code or tons of workflow management code in place, it’s possible that just writing a new db agent will be easier - again, without knowing more about the specific design, it’s hard to say if any one choice is ‘better’.
HTH
Doug