-
Help me on the given Salesforce Trigger Scenario
Scenario 1.
1) Make two number fields on contact object Amount_X Amount_Y
2) Make one picklist field "Type" , values ('Positive', 'Negative')
3) Make two number fields on account Rollup_Amount_X Rollup_Amount_Y Rollup_Amount
4) Make one trigger on contact object, which will do following: --> Sum all child of contact's field "Amount_X" and store in parent account's "Rollup_Amount_X" Where Type is "Positive" --> Sum all child of contact's field "Amount_Y" and store in parent account's "Rollup_Amount_Y" Where Type is "Negative" --> Sum all child of contact's field "Amount_X" + "Amount_Y" and store in parent account's "Rollup_Amount"
5) Make trigger as bulk / Test class
-
2 Replies
-
Hi Sajid,
You can have a trigger something like --
trigger calculateAmount on Contact(after update,after insert){
set<Id> idList = new set<Id>();
List<Account> accList = new List<Account>();
for(Contact con: Trigger.new){idList.add(con.AccountId);
}
List<Account> accList = [Select Id,Rollup_Amount_X__c,Rollup_Amount_Y__c (Select Id,Amount_X__c, Amount_Y__c, Type__c from Contacts) from Account where Id in:idList];for(Account acc: accList){
Integer amountx=0;
Integer amounty=0;
for(Contact con: acc.Contacts){if(con.Type__c=='Positive'){
amountx += con.Amount_X__c;
}else{amounty += con.Amount_Y__c;
}
}
acc.Rollup_Amount_X__c = amountx;
acc.Rollup_Amount_Y__c = amounty;
accList.add(acc)
}update accList;
}Hope this helps.
Thanks,
Subhendu -
Hey sajid,
trigger sumcontact on Contact (after insert , after update) {
list<account> updateacc = new list<account>();
set<id> aid = new set<id>();
for(contact con : trigger.new)
{
aid.add(con.accountid);
}
list<account> acclist =[select id , name,Rollup_Amount__c ,(select id, name,Amount_X__c,Type__c ,Amount_Y__c from contacts ), Rollup_Amount_X__c ,Rollup_Amount_Y__c from account where id in : aid];
for(account acc : acclist)
{
decimal amountx =0.0;
decimal amounty =0.0;
decimal totalsum ;
for(contact con:acc.contacts)
{
if(con.Type__c == 'positive')
{
amountx += con.Amount_X__c;
acc.Rollup_Amount_X__c = amountx;
}
else{
amounty += con.Amount_Y__c;
acc.Rollup_Amount_Y__c = amounty;
}
}
totalsum = amountx + amounty ;
acc.Rollup_Amount__c = totalsum ;
updateacc.add(acc);
}
update updateacc;
}Hope this help for others.
Thanks
Ashi
Log In to reply.
Popular Salesforce Blogs
Switching from MS Dynamics to Salesforce | Learn Here
Introduction Talking about a CRM both MS Dynamics and Salesforce are great platforms to work on. But with the advancement and upgradation in technological development,…
Decorators in LWC | Salesforce Developer Guide
Lightning Web Components (LWC) is a framework provided by Salesforce to develop fast, responsive, and reusable web components for their platform. One of the key…
Salesforce B2B Commerce Cloud for Modern Businesses
In the fast-paced world of digital commerce, businesses are constantly seeking innovative solutions to enhance their online presence and streamline their operations. Salesforce B2B Commerce…
Popular Salesforce Videos
Free 5 Day Salesforce Challenge!
To access the signup form head over to www.talentstacker.com/Salesforce TalentStacker Podcast Salesforce Episode: https://talentstacker.libsyn.com/how-to-earn-60k-100k-a-year-within-6-months-without-a-college-degree-say-what-salesforce-career-development-path-with-bradley-rice Do you already have a job as a Salesforce Professional and…
Salesforce Salaries In Current Market?
Wondering about the Salesforce salaries in the current market. Join this useful group for Salesforce job & career info and learn all about the Salesforce…
What is Audit Trail in Salesforce?
The Setup Audit Trail feature in Salesforce enables you to closely track changes made to your organization. It records all modifications concerning the administration, customization, security,…
