2. PHPRunner General questions
  3. Conditional Send email
This topic is locked

Conditional Send email

 		9/14/2006 10:10:33 AM
PHPRunner General questions
R
 RickG author

Is is possible to create a conditional "send email with new data" event?
Scenario is as follows:

  • Application is a simple leads generation database
  • Leads table is joined to the SalesRep table which contains the SalesRep email address
  • When a new lead is added or edited, user would like "the option" of sending an email to the SalesRep with the lead data.
    I've thought of two ways to address this:
  • create a second "Save" button on the bottom of the page. The second button might say "Save and eMail SalesRep" which is linked to the event. Could require a lot of manual page editing (?)
    OR
  • create a field (displayed to the user as a checkbox) in the Leads table with the caption "eMail SalesRep ?" and evaluate this field in the "send email with new data event." The only caveat is that I'd like the value in this field reset (i.e. not left checked) the next time a user opens the record to edit it.
    Any suggestions as to the best way to accomplish this?
    Many thanks -
    Rick
J
 		Jane 9/15/2006

Rick,
the easiest way is to create new field (eMailSalesRep for example). Then set it as checkbox and add your code in the BeforeEdit event.

Here is a sample code:

function BeforeEdit(&$values, $where)

{
if ($values["eMailSalesRep"]==1)

{

$email="test@test.com";

$message="";

$subject="New data record";
foreach($values as $field=>$value)

$message.= $field." : ".$value."\r\n";
mail($email, $subject, $message);

}
//uncheck this field

$values["eMailSalesRep"]=0;

return true;
}