-
How to Write Salesforce Triggers for this Scenario?
How to write a triggers for this scenario?
1.Create a date field on Contact - MyDate
Create a date field on Account - MyDateWrite a trigger, Whenever a contact record is inserted under an account then the
new record's MyDate field should be 1 month ahead that of its parent Account's MyDate field. And if multiple
contact records
are inserted under one account then the contact records's MyDate field should be 1 month ahead of each other.
For example:
There are 3 records of accounts - A1 (1st July 2017), A2 (1st Jan 2018), A3 (1st Oct 2017)
Now we are inserting multiple contacts under these 3 accounts like this:
A1 --> C1, C2, C3
A2 --> C4, C5, C6, C7
A3 --> C8, C9So the MyDate fields of new contact records should be like this:
C1 - 1st Aug 2017
C2 - 1st Sep 2017 -
4 Replies
-
Hi Pavan,
You can achieve it in before Insert and before update of the contact.
PFB the code for the same -
public class ContactTriggerHelper { /* *call this method on before Insert and before upate of Contact * before insert - * Parameters - Trigger.New, null * * before update - * Parameters - Trigger.New, Trigger.oldMap * */ public static void contactDateUpdate(List<Contact> newList, Map<Id, Contact> oldMap){ Map<Id, List<Contact>> accContactMap = new Map<Id, List<Contact>>(); for(Contact con : newList){ if(oldMap == null && con.AccountId != null){ if(accContactMap.containsKey(con.AccountId)){ accContactMap.get(con.AccountId).add(con); }else{ accContactMap.put(con.AccountId, new List<Contact>{con}); } }else if(oldMap != null && con.AccountId != null && (con.MyDate__c == null || con.MyDate__c != oldMap.get(con.Id).MyDate__c)){ if(accContactMap.containsKey(con.AccountId)){ accContactMap.get(con.AccountId).add(con); }else{ accContactMap.put(con.AccountId, new List<Contact>{con}); } } } Map<Id, Account> accountMap = new Map<Id, Account>([SELECT Id, MyDate__c FROM Account WHERE Id IN: accContactMap.keySet()]); for(Id accId : accContactMap.keySet()){ for(Contact con : accContactMap.get(accId)){ con.MyDate__c = accountMap.get(accId).MyDate__c.addMonths(1); } } } }I hope this will help.
Thanks
Avinash
- [adinserter block='9']
-
Hi Pavan,
Above was a rough code to achieve the requirement.. Although that will also work in every scenario.
Please find more optimized code for the same -
public class ContactTriggerHelper { /* *call this method on before Insert and before upate of Contact * before insert - * Parameters - Trigger.New, null * * before update - * Parameters - Trigger.New, Trigger.oldMap * */ public static void contactDateUpdate(List<Contact> newList, Map<Id, Contact> oldMap){ Set<Id> accIds = new Set<Id>(); for(Contact con : newList){ if(con.AccountId != null){ accIds.add(con.AccountId); } } Map<Id, Account> accountMap = new Map<Id, Account>([SELECT Id, MyDate__c FROM Account WHERE Id IN: accIds]); for(Contact con : newList){ if(oldMap == null && accountMap.get(con.AccountId).MyDate__c != null ){ con.MyDate__c = accountMap.get(con.AccountId).MyDate__c.addMonths(1); }else if(oldMap != null && con.AccountId != null && (con.MyDate__c == null || con.MyDate__c != oldMap.get(con.Id).MyDate__c || con.MyDate__c != accountMap.get(con.AccountId).MyDate__c)){ con.MyDate__c = accountMap.get(con.AccountId).MyDate__c.addMonths(1); } } } }Hope this will help.
Thanks
Avinash
-
This reply was modified 7 years, 7 months ago by
Jade.
-
This reply was modified 7 years, 7 months ago by
-
Thanks a lot for your kind help...
-
No Problem 🙂
Log In to reply.
Popular Salesforce Blogs
Azure with Salesforce for Customer Engagement and Operational Excellence
The retail landscape is in constant flux, driven by evolving customer expectations and disruptive technologies. Staying ahead requires more than just keeping up; it demands…
Migrating to Salesforce: Key Steps for a Seamless Transition
Migrating to Salesforce can transform how your business operates. Whether you're looking to streamline your sales process, improve customer service, or better analyze your data,…
Guide To Writing Batchable Classes In Salesforce
Ever heard of “Batch classes” in Salesforce and felt a bit puzzled? Don’t worry; it’s simpler than you think! Imagine you’re baking cookies. You don’t…
