You need to sign in to do that
Don't have an account?
SFDC n12
Trigger help needed for group account
Hi,
I need help on the following req
1) I am having a custom field called as "Dealer Principal__c" in my custom object called as "Account Exceptions__c"
2) There is a lookup on my custom object called as Account__c which is a lookup to the account object
My req is i want to populate my custom field "Dealer Principal__c" on Account exception__c custom object with the contact first name and last name of the contact related to the account that i select if the contact title is set as "Dealer Principal" (This is done)
if the account record type is group account , the child accounts contact's name is set which is having
contact title as "Dealer Principal" and not the group account contact (need help on it)
My trigger :
trigger updateaccountexceptions on AccountExceptions__c(after insert) {
map < id, string > dealercontacts = new map < id, string > ();
set < id > accids = new set < id > ();
for (AccountExceptions__c acex: trigger.new) {
accids.add(acex.account__c);
}
List < contact > cons = new List < contact > ([select Id, accountid, firstname, lastname from contact where title = 'Dealer Principal'
and accountid = : accids
]);
for (Contact con: cons) {
string conname = con.firstname + ' ' + con.lastname;
dealercontacts.put(con.accountid, conname);
}
list < AccountExceptions__c > acexlisttoupdate = new list < AccountExceptions__c > ();
for (AccountExceptions__c acex: trigger.new) {
AccountExceptions__c accex1 = new AccountExceptions__c();
if (dealercontacts.containskey(acex.account__c)) {
accex1.id = acex.id;
accex1.Dealer_Principal_s__c = dealercontacts.get(acex.account__c);
acexlisttoupdate.add(accex1);
}
}
update acexlisttoupdate;
}
Help me how to get the child account contacts name for account record type is group account
Thanks in Advance
I need help on the following req
1) I am having a custom field called as "Dealer Principal__c" in my custom object called as "Account Exceptions__c"
2) There is a lookup on my custom object called as Account__c which is a lookup to the account object
My req is i want to populate my custom field "Dealer Principal__c" on Account exception__c custom object with the contact first name and last name of the contact related to the account that i select if the contact title is set as "Dealer Principal" (This is done)
if the account record type is group account , the child accounts contact's name is set which is having
contact title as "Dealer Principal" and not the group account contact (need help on it)
My trigger :
trigger updateaccountexceptions on AccountExceptions__c(after insert) {
map < id, string > dealercontacts = new map < id, string > ();
set < id > accids = new set < id > ();
for (AccountExceptions__c acex: trigger.new) {
accids.add(acex.account__c);
}
List < contact > cons = new List < contact > ([select Id, accountid, firstname, lastname from contact where title = 'Dealer Principal'
and accountid = : accids
]);
for (Contact con: cons) {
string conname = con.firstname + ' ' + con.lastname;
dealercontacts.put(con.accountid, conname);
}
list < AccountExceptions__c > acexlisttoupdate = new list < AccountExceptions__c > ();
for (AccountExceptions__c acex: trigger.new) {
AccountExceptions__c accex1 = new AccountExceptions__c();
if (dealercontacts.containskey(acex.account__c)) {
accex1.id = acex.id;
accex1.Dealer_Principal_s__c = dealercontacts.get(acex.account__c);
acexlisttoupdate.add(accex1);
}
}
update acexlisttoupdate;
}
Help me how to get the child account contacts name for account record type is group account
Thanks in Advance
1. fetch the Record type Id
2. filter AccountException__c where related Account Record type id is group account Important :
If this is what you were looking for then please mark it as a "SOLUTION" or You can Click on the "Like" Button if this was beneficial for you.
1) if the account is a nornmal account (PDN Record type) , the contact(name) associated with that account with title "Dealer Principal" is populated to that field
2) If the account is a group account
the group account might have many child accounts , where it will check the contacts of all th e child accounts with the title "Dealer principal" and update the name correspondingly
so my case should work for both the scenarios
First scenario my trigger is working fine , just need help on second one
but if i use the trigger with record type query , the first one wil not work right