-
How we get List of sibling Contact in a Salesforce Trigger?
I want a trigger on contact which prevent delete if there 3 more contact in same Account, please Write Trigger for it.
-
This discussion was modified 8 years, 5 months ago by
Shubham.
-
This discussion was modified 8 years, 5 months ago by Forcetalks.
-
This discussion was modified 8 years, 5 months ago by Forcetalks.
-
This discussion was modified 8 years, 5 months ago by
-
2 Replies
-
Hi Shubham,
You can refer this code for getting all the siblings of any contact.
Set<id> accid = new Set<id>();
for(Contact c : Trigger.old){
accid.add(c.AccountId);
}
List<contact> con = [select id, accountid, Start_Date__c, End_Date__c from contact where Account.Id in : accid AND Id not IN : Trigger.old];Map<id,List<Contact>> mapAccIdCont = new Map<id,List<Contact>>();
for(Contact c :con){
if(mapAccIdCont.containsKey(c.Accountid)){
List<Contact> conList = mapAccIdCont.get(c.AccountId);
conList.add(c);
mapAccIdCont.put(c.AccountId, conList);}
else{
List<Contact> conList = new List<Contact>();
conList.add(c);
mapAccIdCont.put(c.AccountId, conList);}
} -
Trigger AreaCode on Contact (before insert) {
Set <String> InitialContact Name = new Set <String> ();
for(Contact Contact NameLoop : trigger.New)
{
if(ContactNameLoop.Area_Code__c != null){
InitialContactName.add(ContactNameLoop.Area_Code__c);
}}
Map <String, Area_Code__c> matchingAreaCodeMap = new Map <String, Area_Code__c> ();
for (Area_Code__c Record : [Select Id, Name, Market__c From Area_Code__c Where Name IN :InitialContactName])
{
matchingAreaCodeMap.put(Record.name, record);
}for(Contact ContactNameLoop : trigger.New)
{ContactNameLoop.Contact_Market__c = matchingAreaCodeMap.get(ContactNameLoop.Area_Code__c).Market__c;
}
}
Thanks
Log In to reply.
Popular Salesforce Blogs
3 Hot Trends Secretly Pointing towards Future of CRM
Customer Relationship Management or CRM is the future of the business and is not going to fed so soon. Starting from small businesses to the…
What are Validation Rules in Salesforce in 2023?
In this blog, we will explore the importance of validation rules and how to create them in Salesforce. What are Validation Rules in Salesforce? Validation…
What are the top Salesforce Implementation and Consulting Partners for 2023?
Businesses are constantly improving their operations in order to maximize returns on investment. Salesforce CRM is the platform that provides the highest ROI. However, implementing it…
Popular Salesforce Videos
How to Create Contact in Salesforce | Salesforce Contacts | Salesforce Tutorial
Contact in Salesforce represents the individual people associated with the business accounts in your organization or Contact records are used for individuals to store personal…
Build a Discount Approval Process | Step by Step Guide | Trailhead Project
Building a robust discount approval process is the first step in getting a grip of price discounts that are eating into profit. In this video…
5 Tips on How to Run Your Pipeline Engine to Drive Growth | Salesforce on Salesforce
Salesforce’s revenue has been on a firm upward trajectory for years, and every year we see terrific growth. How do we do it? I’ll let…
