2. PHPRunner General questions
  3. Send an email to user at different stages of Job
This topic is locked

Send an email to user at different stages of Job

 		10/23/2015 9:28:41 AM
PHPRunner General questions
M
 mfriend author

Hi Folks:
I'm working on developing a "help desk" type app. The users submit work orders for things needing repaired/fixed. The main stakeholder decided yesterday that he would like the person who submitted the work order to receive an email when things with the work order change.
So they might receive an email when the Work order has been assigned, then again when it is being worked on, and finally when it is complete.
The data I believe will all be coming from one table. A field in that one table would contain their email address. I think if an email could be sent each time that a row is added or edited to the email address in that row that would be great.
I looked at the advanced section in the manual that deals with sending emails, but it looks like that would only send emails to a static address? I would need to replace the recipients email address with the address of the users email in that affected row.
Any help is appreciated...
Matthew
P.S. Not sure if it makes any difference but the database is an Oracle 12c database.
Sergey Kornilov admin 10/23/2015

You can use event like AfterEdit for this purpose. If email address is stored right in that record you can use something like $values["EmailField"] instead of hardcoded email address.
More info on AfterEdit event:

http://xlinesoft.com/phprunner/docs/after_record_updated.htm
M
 		mfriend author 10/23/2015



You can use event like AfterEdit for this purpose. If email address is stored right in that record you can use something like $values["EmailField"] instead of hardcoded email address.
More info on AfterEdit event:

http://xlinesoft.com/phprunner/docs/after_record_updated.htm



Thank you for the help.
I'll give that a try when I reach that stage of the project.
Matthew