Apex Code Development You need to sign in to do that
Don't have an account?
syam11 trigger when ever Email/ phone of the account is updated ,all the contact email should be same
HI all
Im new to salesforce . i want to write a trigger when ever Email/ phone of the account is updated ,all the contact email should be same. any one help me to solve
Thank you
Harsha
Im new to salesforce . i want to write a trigger when ever Email/ phone of the account is updated ,all the contact email should be same. any one help me to solve
Thank you
Harsha
Set<Id> setAccountId = new Set<Id>();
for(Account acc:trigger.new) {
if(Trigger.oldMap.get(acc.ID).Email__c != acc.Email__c || Trigger.oldMap.get(acc.ID).phone != acc.phone) {
setAccountId.add(acc.id);
}
}
List<Contact> lstContact = new List<Contact>();
for(Account acc:[Select id,Email__c,(select id,Email from Contacts) from Account where Id in:setAccountId]) {
for(Contact con:acc.contacts) {
if(con.Email != acc.Email__c) {
con.Email = acc.Email__c;
lstContact.add(con);
}
}
}
if(lstContact.size() >0) {
update lstContact;
}
}
Please use this trigger code Harsha .
All Answers
Set<Id> setAccountId = new Set<Id>();
for(Account acc:trigger.new) {
if(Trigger.oldMap.get(acc.ID).Email__c != acc.Email__c || Trigger.oldMap.get(acc.ID).phone != acc.phone) {
setAccountId.add(acc.id);
}
}
List<Contact> lstContact = new List<Contact>();
for(Account acc:[Select id,Email__c,(select id,Email from Contacts) from Account where Id in:setAccountId]) {
for(Contact con:acc.contacts) {
if(con.Email != acc.Email__c) {
con.Email = acc.Email__c;
lstContact.add(con);
}
}
}
if(lstContact.size() >0) {
update lstContact;
}
}
Please use this trigger code Harsha .