-
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
Landing Page Login Form And Save Data In Salesforce Data Extensions
As all we know, Salesforce Marketing Cloud is a tool that provides digital marketing automation and services and analytics software. And Landing page is an…
A Deep Dive Into Salesforce Winter '23 Analytics Updates
In this blog, we take a look at the new features and updates to Salesforce Analytics from the Winter '23 release. Custom Report Types As…
Displaying data from the related Supplier__c records on a Visualforce page that has a custom controller for the Buyer__c object
How can a developer display data from the related Supplier__c records on a Visualforce page that has a custom controller for the Buyer__c object? The…
Popular Salesforce Videos
How To Create A Case Assignment Rule In Salesforce
Learn all about how to create Case Assignment rules. In this video, the following points will be covered - 1. Introduction To Case Assignment Rule…
Building a Custom UI with Lightning Web Components | Salesforce Tutorial
Lightning Web Components is a modern JavaScript framework that leverages the web standards breakthroughs over the past few years. Watch this session to understand how…
How To Use Data Loader In Salesforce - Learn Salesforce Series By Algoworks
Learn how to use Data Loader in Salesforce. In this video, the following points will be covered - 1. Introduction Here you will get a…
