Apex Code Development You need to sign in to do that
Don't have an account?
venkateshyadav1243 trigger automatically creating the events records and updating the records
hi i write trigger on my custom object when it will update first time i have to create event ,if i update next time its only update
i write trigger it will not updating its only creating can any one tel me where am doing mistak.
my trigger scenario is i have a filed called sales ready date in my custom object if i change tht date my event details will be updated .
below is my trigger
trigger TGR_EventDateOppName on Factory__c (after insert,before update) {
try{
Factory__c dgital=[select id,Sales_Ready_Date__c from Factory__c where id=:trigger.new ];
list<Event> newevent=new list<Event>();
Opportunity opp=[select id,name from Opportunity where id in (select Opportunity__c from factory__c where id=:trigger.new)];
system.debug('&&&'+opp);
for(factory__c df:trigger.new)
{
if(df.Sales_Ready_Date__c !=null)
{
Event e = new Event();
e.StartDateTime =df.Sales_Ready_Date__c;
e.EndDateTime =df.Sales_Ready_Date__c.addDays(1);
e.Subject =opp.name;
e.WhatId=df.id;
newevent.add(e);
}
}
insert newevent;
Event e=[select id,StartDateTime,EndDateTime from event where WhatId in(select Opportunity__c from factory__c where id=:trigger.new)];
system.debug('&&&'+e);
for(factory__c dfc:trigger.new)
{
e.StartDateTime =dfc.Sales_Ready_Date__c;
e.EndDateTime =dfc.Sales_Ready_Date__c.addDays(1);
}
update newevent;
system.debug('^^^^^^^^^^^^'+newevent);
}catch(Exception e){system.debug('&*&*'+e);}
}
trigger TGR_EventDateOppName on Factory__c (after insert,before update) { if(trigger.isInsert) { List<Event> eventList = new List<Event>(); for(Factory__c fac : Trigger.new) { if(fac.Sales_Ready_Date__c != null) { Event e = new Event(); e.StartDateTime = fac.Sales_Ready_Date__c; e.EndDateTime = fac.Sales_Ready_Date__c.addDays(1); e.Subject = fac.Opportunity__r.Name; e.WhatId = fac.Id; eventList.add(e); } } insert eventList; } if(trigger.isUpdate) { List<Id> facIds = new List<Id>(); Map<Id, Event> eventMap = new Map<Id, Event>(); List<Event> eventList = new List<Event>(); for(Integer i = 0; i < Trigger.new.size(); i++) { if(Trigger.new[i].Sales_Ready_Date__c <> Trigger.Old[i].Sales_Ready_Date__c) { facIds.add(Trigger.new[i].Id); } } for(Event ev : [SELECT Id, WhatId, StartDateTime, EndDateTime FROM Event WHERE WhatId IN :facIds]) { eventMap.put(ev.WhatId, ev); } for(Factory__c dfc : Trigger.new) { Event evnt = eventMap.get(dfc.Id); if(evnt <> null) { evnt.StartDateTime = dfc.Sales_Ready_Date__c; evnt.EndDateTime =dfc.Sales_Ready_Date__c.addDays(1); eventList.add(evnt); } } update eventList; } }try this.
All Answers
trigger TGR_EventDateOppName on Factory__c (after insert,before update) { if(trigger.isInsert) { List<Event> eventList = new List<Event>(); for(Factory__c fac : Trigger.new) { if(fac.Sales_Ready_Date__c != null) { Event e = new Event(); e.StartDateTime = fac.Sales_Ready_Date__c; e.EndDateTime = fac.Sales_Ready_Date__c.addDays(1); e.Subject = fac.Opportunity__r.Name; e.WhatId = fac.Id; eventList.add(e); } } insert eventList; } if(trigger.isUpdate) { List<Id> facIds = new List<Id>(); Map<Id, Event> eventMap = new Map<Id, Event>(); List<Event> eventList = new List<Event>(); for(Integer i = 0; i < Trigger.new.size(); i++) { if(Trigger.new[i].Sales_Ready_Date__c <> Trigger.Old[i].Sales_Ready_Date__c) { facIds.add(Trigger.new[i].Id); } } for(Event ev : [SELECT Id, WhatId, StartDateTime, EndDateTime FROM Event WHERE WhatId IN :facIds]) { eventMap.put(ev.WhatId, ev); } for(Factory__c dfc : Trigger.new) { Event evnt = eventMap.get(dfc.Id); if(evnt <> null) { evnt.StartDateTime = dfc.Sales_Ready_Date__c; evnt.EndDateTime =dfc.Sales_Ready_Date__c.addDays(1); eventList.add(evnt); } } update eventList; } }try this.