Apex Code Development You need to sign in to do that
Don't have an account?
First Trigger Help - Update field on another object
Hi, I am trying to write my first trigger and need some help.
We have a custom object called Employee that has a field named "Scheduled Review Date".
I need to create a trigger that upon creation of an Event record this field is updated with the date from Event in field "StartDateTime" < API name. The Related to (who) field on event is my employee.
I have come up with this so far:
I'm not sure where to go from here. I think I need to query employee and then put the field update but I don't really know how to do this.
I think this is pretty simple so hopefully someone can point me in the right direction.
Thanks!
Matt
We have a custom object called Employee that has a field named "Scheduled Review Date".
I need to create a trigger that upon creation of an Event record this field is updated with the date from Event in field "StartDateTime" < API name. The Related to (who) field on event is my employee.
I have come up with this so far:
trigger ScheduledReviewDate on Event (after insert) {
for (Event e: trigger.new){
}
}
I'm not sure where to go from here. I think I need to query employee and then put the field update but I don't really know how to do this.
I think this is pretty simple so hopefully someone can point me in the right direction.
Thanks!
Matt
Is there any relationship with Event and Employees__c ,Are you creating event under employee . If like that
trigger scheduleReviewDate on Event(after insert){ Map<Id,Date> empIdWithDate=New Map<Id,Date>(); for(Event evt :Trigger.New ){ empIdWithDate.put(evt.Employee__c,evt.StartDateTime ); } List<Employee__c> empList=new List<Employee__c>(); For(Employee__c emp: [SELECT Id,Date__c FROM Employee__c WHERE Id IN: empIdWithDate.keySet()]){ emp.Date__c=empIdWithDate.get(emp.Id); empList.add(emp); } try{ Upadte empList; }catch(DMLException de){ } }Replace Date__c with your Employee__c Date field .All Answers
List<Contact> lstContact = new List<Contact>(); for(Event e : [select WhoId from Event where Id IN : trigger.new]) { if(e.WhoId.getSobjectType() == Contact.sobjectType) lstContact.add(new Contact(Id = WhoId, Scheduled_Review_Date__c = date.newinstance(e.StartDateTime.year(), e.StartDateTime.month(), e.StartDateTime.day()); ); } update lstContact;Can you put some notes in this code telling me what each step is doing? I am looking for more of a training so I can understand what each step is doing.
trigger scheduleReviewDate on Event(after insert) { List<Contact> lstContact = new List<Contact>(); for(Event e : [select WhoId, StartDateTime from Event where Id IN : trigger.new]) { if(e.WhoId.getSobjectType() == Contact.sobjectType)//checking whoId belongs to Contact lstContact.add(new Contact(Id = WhoId, Scheduled_Review_Date__c = date.newinstance(e.StartDateTime.year(), e.StartDateTime.month(), e.StartDateTime.day())));//storing the Contact in a list with assigning the date value of StartDateTime field to Schedule review date } update lstContact;//updating contact list }Please try this code.Another item: Is this referencing the SF native object Contact or is that just the name you used for the list? The record I am writting to is stored on a custom object named Employee.
Use e.WhoId instead of WhoId. I have a question. Is your Contact object is same as Employee object? If this is not, then use : if(e.WhatId.getSobjectType() == Employee__c.sobjectType))
lstContact.add(new Contact(Id = e.WhatId, Scheduled_Review_Date__c =date.newinstance(e.StartDateTime.year(), e.StartDateTime.month(), e.StartDateTime.day())));//storing the Contact in a list with assigning the date value of StartDateTime field to Schedule review date
Is there any relationship with Event and Employees__c ,Are you creating event under employee . If like that
trigger scheduleReviewDate on Event(after insert){ Map<Id,Date> empIdWithDate=New Map<Id,Date>(); for(Event evt :Trigger.New ){ empIdWithDate.put(evt.Employee__c,evt.StartDateTime ); } List<Employee__c> empList=new List<Employee__c>(); For(Employee__c emp: [SELECT Id,Date__c FROM Employee__c WHERE Id IN: empIdWithDate.keySet()]){ emp.Date__c=empIdWithDate.get(emp.Id); empList.add(emp); } try{ Upadte empList; }catch(DMLException de){ } }Replace Date__c with your Employee__c Date field .I updated the code to this using my fields on Employees__c
trigger scheduleReviewDate on Event(after insert){ Map<Id,Date> empIdWithDate=New Map<Id,Date>(); for(Event evt :Trigger.New ){ empIdWithDate.put(evt.Employees__c,evt.StartDateTime ); } List<Employees__c> empList=new List<Employees__c>(); For(Employees__c emp: [SELECT Id,Scheduled_Review_Date__c FROM Employees__c WHERE Id IN: empIdWithDate.keySet()]){ emp.Scheduled_Review_Date__c=empIdWithDate.get(emp.Id); empList.add(emp); } try{ Update empList; }catch(DMLException de){ } }I am getting an error however:Error: Compile Error: Invalid field Employees__c for SObject Event at line 4 column 21
P.S. you had a small mistype of the word "update".
Click on setup >Customise >ActivityCustomFields > Check the lookup field name in Event which is to Employee add that filed Name .
Here are some screenshots that might help.
Event Fields
Here is an actual Event for an Employees__c record.
trigger scheduleReviewDate on Event(after insert){ Map<Id,Datetime> empIdWithDate=New Map<Id,Datetime>(); for(Event evt :Trigger.New ){ empIdWithDate.put(evt.What.Id,evt.StartDateTime ); } List<Employees__c> empList=new List<Employees__c>(); For(Employees__c emp: [SELECT Id,Scheduled_Review_Date__c FROM Employees__c WHERE Id IN: empIdWithDate.keySet()]){ emp.Scheduled_Review_Date__c=empIdWithDate.get(emp.Id); empList.add(emp); } try{ Update empList; }catch(DMLException de){ } }It is evt.WhatId not evt.What.Id
trigger scheduleReviewDate on Event(after insert){ Map<Id,Datetime> empIdWithDate=New Map<Id,Datetime>(); for(Event evt :Trigger.New ){ empIdWithDate.put(evt.WhatId,evt.ActivityDate ); } List<Employees__c> empList=new List<Employees__c>(); For(Employees__c emp: [SELECT Id,Scheduled_Review_Date__c FROM Employees__c WHERE Id IN: empIdWithDate.keySet()]){ emp.Scheduled_Review_Date__c=empIdWithDate.get(emp.Id); empList.add(emp); } try{ Update empList; }catch(DMLException de){ } }I also would like to share some more optimized code:
trigger scheduleReviewDate on Event(after insert){ Map<Id,Employee__c> mapIdToEmp = new Map<Id,Employee__c>(); for(Event e: [select Employee__c, StartDateTime from Even where Id In : Trigger.new]) { if(e.Employee__c!=null) mapIdToEmp.put(e.Employee__c, new Employee__c(Id = e.Employee__c, Date__c = e.StartDateTime)); } update mapIdToEmp.values();The code that Manoj made for me works after I updated a few items on it.
You need to add on line more in that trigger to fire only for the event which will create under Employee__c ,Else it will fire for event creation from all object and chances are there to throw error .
trigger scheduleReviewDate on Event(after insert){ Map<Id,Datetime> event_EmpIdWithDate = New Map<Id,Datetime>(); for(Event evt :Trigger.New ){ event_EmpIdWithDate.put(evt.WhatId,evt.StartDateTime ); } List<Employees__c> empList = new List<Employees__c>(); For(Employees__c emp: [SELECT Id,Scheduled_Review_Date__c FROM Employees__c WHERE Id IN: event_EmpIdWithDate.keySet()]){ emp.Scheduled_Review_Date__c = event_EmpIdWithDate.get(emp.Id); empList.add(emp); } try{ Update empList; }catch(DMLException de){ } }Hi I am writing my first trigger. Please help.
I have two objects - CourseOffering and CourseConnection, there is a field in CourseOffering named 'Faculty. I want to write a trigger by which on updating Faculty, Course Connection's field named 'Status' changes to 'Former' from 'Current'.
Is there a lookup or master detail relationship between CourseOfferring__c and CourseConnection__c?