-
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
How to Use Map In Lightning Component?
For using the map in the lightning component, we need to define the attribute of the type map to hold key-value pairs. In this blog,…
Mastering Salesforce Packages: Managed vs. Unmanaged
Salesforce packages simplify application development, deployment, and distribution in the Salesforce ecosystem. This blog explores Salesforce packages, their significance for administrators, developers, and users. We'll…
How to Choose the Right Salesforce Consulting Partner?
What is the secret to a successful Salesforce CRM implementation for an organization? Clear objectives, customization and configuration, seamless integration of third-party systems as well…
Popular Salesforce Videos
Enhance Multi-Select Picklist Functionality With Flows to Increase Reportability | Salesforce
Multi-select picklists are AMAZING but have some MAJOR downsides. Do you like the functionality of muti-selects but hate reporting on them? Does the easy user…
Apex Performance Tips and Tricks | Salesforce Video Guide
Watch this video to learn all about Apex Performance: • What do we mean by performance? • How do we measure performance? • Loop Performance…
Salesforce Demo - Sales Dashboard Example
Our team created a comprehensive sales dashboard for one of our clients. We're posting this video about it to generate feedback and additional ideas for…
