In the below example, when the Account's Billing Street or City gets updated, it's related Contacts Mailing Street and City are updated from Account's Billing Street and City.
Sample trigger:
trigger ContactUpdate on Account (after update) {
Map < Id, Account > mapAccount = new Map < Id, Account >();
List < Contact > listContact = new List< Contact >();
for ( Account acct : trigger.new ) {
/* Checking whether Account's Billing Street or City Changed */
if ( acct.BillingStreet != trigger.oldMap.get( acct.Id ).BillingStreet ||
acct.BillingCity != trigger.oldMap.get( acct.Id ).BillingCity )
mapAccount.put( acct.Id, acct );
}
if ( mapAccount.size() > 0 ) {
/* Fetching all the contacts related to the update accounts */
listContact = [ SELECT MailingStreet, MailingCity, AccountId FROM Contact WHERE AccountId IN : mapAccount.keySet() ];
if ( listContact.size() > 0 ) {
for ( Contact con : listContact ) {
/* Updating Contact's Mailing Street and City from Account's Billing Street and City */
con.MailingStreet = mapAccount.get( con.AccountId ).BillingStreet;
con.MailingCity = mapAccount.get( con.AccountId ).BillingCity;
}
update listContact;
}
}
}
Map < Id, Account > mapAccount = new Map < Id, Account >();
List < Contact > listContact = new List< Contact >();
for ( Account acct : trigger.new ) {
/* Checking whether Account's Billing Street or City Changed */
if ( acct.BillingStreet != trigger.oldMap.get( acct.Id ).BillingStreet ||
acct.BillingCity != trigger.oldMap.get( acct.Id ).BillingCity )
mapAccount.put( acct.Id, acct );
}
if ( mapAccount.size() > 0 ) {
/* Fetching all the contacts related to the update accounts */
listContact = [ SELECT MailingStreet, MailingCity, AccountId FROM Contact WHERE AccountId IN : mapAccount.keySet() ];
if ( listContact.size() > 0 ) {
for ( Contact con : listContact ) {
/* Updating Contact's Mailing Street and City from Account's Billing Street and City */
con.MailingStreet = mapAccount.get( con.AccountId ).BillingStreet;
con.MailingCity = mapAccount.get( con.AccountId ).BillingCity;
}
update listContact;
}
}
}
Output:
Account:
Contacts:
tqq...........your post..
ReplyDeleteperfect
ReplyDeleteThank you so much . Its really helpful !
ReplyDeleteCan you please update for same object. Example when updating parent account, related child accounts needs to be updated.
ReplyDeleteFor Assets, it's possible with RootAssetId. For account, it is if you have fetch only child accounts(one level only).
DeleteHow to implement this trigger for after insert. I want child record to be updated with another parent record if field value does not matches with current parent record
ReplyDeletePlease suggest
Use after insert event.
DeleteGet the child records using SOQL and update it accordingly by iterating it inside a for loop. Use a list variable to add the changes and update it after the for loop.
This comment has been removed by the author.
ReplyDeleteYou cannot use Policy__r.District_Acct_Code__c and Account_Transfer__r.District_From__c without querying it. So, you are getting null pointer exception.
DeleteIs this code bulkified?
ReplyDeleteYes. No DML or SOQL inside for loop.
DeleteWhat will happen if any contact update failed, will it revert the changes on account ?
ReplyDeleteYes. I haven't used partial DML here.
DeleteThank You so Much, This is very useful
ReplyDeleteVery useful. Can you please share code on rollup summary trigger for look up relationship
ReplyDeleteCheck this - https://www.infallibletechie.com/2013/09/trigger-to-count-number-of-contacts.html
Delete