Use the "After Update" Event to Send Emails

You previously added the necessary code that sends email notification to the assignee upon recording a new task in the system. We shall now implement similar functionality in After Update Event to notify the assignee when an existing task is updated and reassigned to someone.

1. Click on the tasks form in the Project Explorer.
2. In the Properties window, select the Events tab.
3. Add the following Custom Code in After Update event:

   <CFIF flduser_id_assign_to NEQ Session.UserID>
    <CF_CCToSQL Value="#flduser_id_assign_to#" Type="#ccsInteger#">
    <CF_CCDLookUp Field="email" Table="employees" Where="emp_id=#CCToSQL#" Connection="IntranetDB">
    <CFSET mai1_To=CCDLookUp>
    <CF_CCToSQL Value="#Session.UserID#" Type="#ccsInteger#">
    <CF_CCDLookUp Field="email" Table="employees" Where="emp_id=#CCToSQL#" Connection="IntranetDB">
    <CFSET mai1_From=CCDLookUp>
    <CF_CCGetParam strName="task_id" def="">
    <CFMAIL TO="#mai1_To#" FROM="#mai1_From#" SUBJECT="New task for you" TYPE="HTML">
       The following task was assigned to you:<br><br>
       Task ID:#CCGetParam#
       <br><br>#fldtask_desc#
    </CFMAIL>
   </CFIF>

   
   

   The main differences between the above code and that which was used in the After Insert event are as follows:

   1. An if condition was added to send an email only if a user assigns a task to someone other than himself/herself
   2. task_id is retrieved from the URL using the CCGetParam custom tag. We can use this method because tasks can be updated only if the user arrived at the current page via a URL that contains the task id to be updated. Such a URL would look like this: http://localhost/TaskManager/tasks_maint.cfm?task_id=9

Next: Test Email Delivery