Hey guys, today in this post we are going to learn about Apex trigger on Account to create and count the number of Contact records associated with Account object based on custom field when Account record is created/updated in Salesforce.
Real time scenarios:- Write a trigger on Account object where create a custom field as Employee (Number type).
If user insert the parent record, the child record should be automatic inserted equal to the same value of employee.
Or if user update the value of employee less then the total number of child records, in this case the child records should be exist only equal to value of employee size, rest records of child object should be automatic removed.
Files we used in this post example
| EmployeeSizeTrigger2.apxt | Apex Class Trigger | It will be fired whenever insert or update a record on parent object |
|
Parent Cusotm Object:- Account Custom Field:- Employee Size (Employee__c) |
Parent Object with Custom Field | Trigger on Account object and update the count of related child records with the custom field value of Account object. |
|
Child Custom Object:- Contact Custom Field:- AccountId : Lookup(Account) |
Child Object with Lookup Field |
Live Example
Other related post that would you like to learn in Salesforce
- Find the below steps ▾
Create Apex Trigger
Step 1:- Create Apex Trigger : employeeSizeTrigger2.apxt
From Developer Console >> File >> New >> Apex Trigger
employeeSizeTrigger2.apxt [Apex Class Controller]
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 |
trigger employeeSizeTrigger2 on Account (before insert, before update, after insert, after update, before delete, after delete) { Map<Id, List<Contact>> prntMap = new Map<Id, List<Contact>>(); Map<Id, Account> prntOldMap = new Map<Id, Account>(); Map<Id, Integer> prntMapChildNo = new Map<Id, Integer>(); Map<Id, Decimal> empValMap = new Map<Id, Decimal>(); Set<Id> parentKey = prntMap.keySet(); List<List<Contact>> childKeyVal = new List<List<Contact>>(); List<Account> oldVal = new List<Account>(); Set<Id> prntSetId = new Set<Id>(); List<Contact> childObjList = new List<Contact>(); List<Contact> childObjNull = new List<Contact>(); Set<Id> childNullSetId = new Set<Id>(); Decimal childSize; Decimal empVal; Decimal empValOld; if(trigger.isBefore){ system.debug('Event before trigger'); }else if(trigger.isAfter){ system.debug('Event after trigger'); oldVal = trigger.old; for(Account par: [Select Id, Name, Phone, Employee__c, (Select Id, Name, FirstName, LastName, AccountId From Contacts) From Account Where Id IN: trigger.newMap.values()]){ system.debug('par$$$$$$ ' + par); prntMap.put(par.Id, par.Contacts); prntMapChildNo.put(par.Id, (par.Contacts).size()); } system.debug('empValOld# ' +empValOld); for(List<Contact> childObjVal:prntMap.values()){ system.debug('childObj!!!! ' + childObjVal); childKeyVal.add(childObjVal); } system.debug('childKeyVal## ' + childKeyVal); List<Account> prntList = [Select Id, Name From Account Where Id IN:prntMap.keySet()]; for(Account pr1:prntList){ prntSetId.add(pr1.Id); } system.debug('prntSetId ' + prntSetId); for(Account prantEmp:[Select Id,Employee__c From Account Where Id IN:prntMap.keySet()]){ empValMap.put(prantEmp.Id, prantEmp.Employee__c); empVal = prantEmp.Employee__c; system.debug('empValMap ' + empValMap); } system.debug('empValMap ' + empValMap); system.debug('empVal ' + empVal); List<Contact> childObjKey = new List<Contact>(); for(Contact childKey: [Select Id, Name, AccountId From Contact Where AccountId=:prntSetId]){ system.debug('childKey####$ ' + childKey); childObjKey.add(childKey); } if(trigger.isInsert){ for(Integer i=0; i<empVal; i++){ for(Account prntSet:[Select Id, Name From Account Where Id IN:prntSetId]){ Contact childObj = new Contact(); childObj.LastName='childMap ' + i; childObj.AccountId=prntSet.id; childObjList.add(childObj); } } system.debug('childObjList ' + childObjList); insert childObjList; }else if(trigger.isUpdate){ for(Account parOld: oldVal){ empValOld = parOld.Employee__c; } if(empVal !=empValOld){ for(Integer intNo:prntMapChildNo.values()){ system.debug('intNo@@ ' + intNo ); childSize = intNo; } system.debug('childSize ' + childSize); if(empVal > childSize){ empVal = empVal - childSize; for(Integer i=0; i<empVal; i++){ for(Account prntSet1:[Select Id, Name From Account Where Id IN:prntSetId]){ Contact childObj2 = new Contact(); childObj2.LastName='update child ' + i; childObj2.AccountId=prntSet1.Id; childObjKey.add(childObj2); } } upsert childObjKey; }else{ empVal = childSize - empVal; system.debug('empVal $$$ ' + empVal ); for(Integer i=0; i<empVal; i++){ childObjKey[i].AccountId=null; childObjNull.add(childObjKey[i]); } update childObjNull; for(Contact childSet:childObjNull){ childNullSetId.add(childSet.Id); } system.debug('childNullSetId## ' + childNullSetId); List<Contact> deleteNull = [Select Id From Contact Where ID IN:childNullSetId]; delete deleteNull; } } } } } |
Further post that would you like to learn in Salesforce
How many records can trigger handle?
When more than 200 records need to be triggered, Salesforce runs the trigger in chunks of 200. So, if 1000 records are updating, Salesforce runs the trigger 5 times on 200 records each time
Can we have roll up summary fields in case of parent/child relationship?
Yes, we can create Roll up Summary field on parent object only with master detail relation between objects.
How many records will execute in trigger in one execution?
Triggers execute on batches of 200 records at a time. So if 400 records cause a trigger to fire, the trigger fires twice, once for each 200 records. For this reason, you don't get the benefit of SOQL for loop record batching in triggers, because triggers batch up records as well.
Related Topics | You May Also Like
Apex trigger to create and count the number of child records associated with parent object based on custom field when parent record is created/updated in Salesforce | Count the number of child record using trigger in Salesforce
Trigger to update count of child records with custom field of parent object | count of child records on parent for lookup relationship uses of apex trigger in Salesforce
Apex Trigger on Contact to Create Account Automatically and map to related account Id to Contact Whenever New Contact is Created in Salesforce | trigger to create account automatically whenever contact is created in salesforce
Write a Apex trigger to Add the Contact First Name and Last Name to Associated Account Custom Field Whenever the Contact inserted or Updated in Salesforce | Trigger to update Associated Account Custom Field
Trigger to update parent records field when child record is updated | update parent field from child using apex trigger
Create rollup summary using Apex trigger on custom object | rollup summary trigger for count of child records on custom object in Salesforce example
Create a Apex Trigger on Account to Update the Associated Contact Account Name Null Whenever Account Record is Updated in Salesforce | trigger to update account name of contact whenever account record is updated
Trigger on contact to update a account custom field | Write a trigger on contact and update the account custom field uses of apex trigger in Salesforce
- Your reaction of the article ▾
Author of w3web.net
Hi, I am a senior software developer and working in MNC company from more than 8 years. I am great fan of technology, configuration, customization & development. Apart of this, I love to write about Blogging in spare time, Working on Mobile & Web application development, Salesforce lightning, Salesforce LWC and Salesforce Integration development in full time. [Read full bio] | | The Sitemap where you can find all published post on w3web.net