Trigger to add a custom object when Opportunity is created

Question

Hi Everyone,

I've created a simpletrigger that creates a new record of custom object: Hosted_PBX_Deployment__c when a new Opportunity is created.

Now I need to set a value to a fiield: Rack_4_19_two_post_Qty__c in custom object that depends on a value of an Account field: All_Network_Devices_Qty__c

so if Account.All_Network_Devices_Qty__c <=11 then Rack_4_19_two_post_Qty__c =1

what is the best way to reffer to an Account field from Hosted_PBX_Deployment__c trigger?

this is my trigger:

trigger AutoCreateHPBXdeployment on Opportunity (after insert) {

List<Hosted_PBX_Deployment__c> newHPBX = new List<Hosted_PBX_Deployment__c>();

for (Opportunity opp : Trigger.new) {

if(opp.Hosted_PBX__c=='Yes'){

Hosted_PBX_Deployment__c hpbx = new Hosted_PBX_Deployment__c();

hpbx.Opportunity__c = opp.Id;

hpbx.Opportunity_Account__c = opp.AccountId;

newHPBX.add(hpbx);

}

insert newHPBX;

}

Thank you!

Surya v · Accepted Answer

@Serghei Sleptov - Yes..using set will be better approach.

@Krishnakumari - Thanks for bringing up process builder, Certainly that would be easy and OOB. But the original Question was asked for trigger...

--

Thanks,

Prashant

Surya v · Answer

Hi Serghei, A map would be the best way is to achieve the account fields..this will help you to avoid the nest for loop..if you not use map(collection) then you need to query the account related to the opportunity and loop through to get the All_Network_Devices_Qty__c field. trigger AutoCreateHPBXdeployment on Opportunity (after insert) { List newHPBX = new List(); List ids =new List(); for(Opportunity ops:trigger.new){ ids.add(ops.accountid); } map mapacc=new map([select id,All_Network_Devices_Qty__c,(select id from Opportunities) from account where id=:ids]); for (Opportunity opp :trigger.new) { Hosted_PBX_Deployment__c hpbx = new Hosted_PBX_Deployment__c(); hpbx.Opportunity__c = opp.Id; if(mapacc.get(opp.accountid).All_Network_Devices_Qty__c<11){ hpbx.Rack_4_19_two_post_Qty__c=1; } newHPBX.add(hpbx); } if(newHPBX.size()>0) insert newHPBX; } Let me know if this solution works for you -- Thanks, Prashant

Trigger to add a custom object when Opportunity is created

Apex

相关学习

更多帮助