A client of mine is trying to send out an email template from an object that lookups to another. I need to pull all of the information down to the children to send off multiple email alerts with all of the information on the parent. There are more than 15 fields that I need to populate in the child record from the parent so formula fields are out of the question along with field updates. Does anybody have some code or know how to create a trigger that basically triggers an update to a child record when the parent is saved? I also need the fields to populate at the time of the save so when the workflow rule triggers to send out the email alert we have all of the information that we need.
The objects are Work Order and ServiceMax Event. The ServiceMax Event object is the child to the Work Order object. ServiceMax Events are created when dispatching Work Orders to technicians and each technician is associated to a ServiceMax Event, but only one is associated directly to the Work Order. We need an email alert to trigger to each technician upon confirmation, but only one is directly related to the Work Order. So, when confirming the work order I need a trigger to edit all of the children to bring over the information on the Work Order object to the ServiceMax Event records that are related and upon the save an email alert will go out to each of them.
A client of mine is trying to send out an email template from an object that lookups to another. I need to pull all of the information down to the children to send off multiple email alerts with all of the information on the parent. There are more than 15 fields that I need to populate in the child record from the parent so formula fields are out of the question along with field updates. Does anybody have some code or know how to create a trigger that basically triggers an update to a child record when the parent is saved? I also need the fields to populate at the time of the save so when the workflow rule triggers to send out the email alert we have all of the information that we need.
The objects are Work Order and ServiceMax Event. The ServiceMax Event object is the child to the Work Order object. ServiceMax Events are created when dispatching Work Orders to technicians and each technician is associated to a ServiceMax Event, but only one is associated directly to the Work Order. We need an email alert to trigger to each technician upon confirmation, but only one is directly related to the Work Order. So, when confirming the work order I need a trigger to edit all of the children to bring over the information on the Work Order object to the ServiceMax Event records that are related and upon the save an email alert will go out to each of them.
