1.
when ever a record is inserted to the account automatically inserted to the contact
trigger SCENARIO1 on Account (after insert) {
list<contact> c=new list<contact>();
for(account a:trigger.new)
{
contact b=new contact();
b.LastName=a.Name;
b.AccountId=a.Id;
c.add(b);
}
insert c;
}
===================================================================================
=====
2.when ever a record is inserted to the contact automatically inserted to the account
trigger scenario2 on Contact (after insert) {
if(Recursive.flag)
{
Recursive.flag=false;
list<account>a=new list<account>();
for(contact c:trigger.new)
{
account a1=new account();
a1.Phone=c.Phone;
a1.Name=c.LastName;
a.add(a1);
}
insert a;
}
Recursive trigger fire:
3.avoid recursive trigger
public class Recursive {
public static boolean flag=true;
===================================================================================
===========
3.when ever a create opportunity object record updated total opportunies and total amount in account object
trigger scenario24 on Opportunity (after insert) {
set<id>ids=new set<id>();
for(Opportunity op:trigger.new)
{
ids.add(op.accountid);
}
list<account>ac=[select Total_opportunities__c,Total_Amount__c,(select id,Amount from Opportunities ) from a
ccount where id=:ids];
for(account a:ac)
{
a.Total_opportunities__c=a.opportunities.size();
decimal sum=0;
for(opportunity p:a.opportunities)
{
sum=sum+p.amount;
}
a.Total_Amount__c=sum;
}
update ac;
}
===================================================================================
===================
4.contact object when ever department equal to cse automatically before inserted email field
trigger scenario4 on Contact (before insert) {
for(contact c:trigger.new)
{
if(c.Department=='CSE')
{
c.Email='
[email protected]';
}
}
===================================================================================
========
5.when ever we modify inputout object doctorname automatically update droppoff object text field no relation ship
trigger SCENARIO32 on Inputout__c (after update) {
list<Dropoff1__c>d=[select id,name,Text__c from Dropoff1__c where Text__c='naveen'];
string name;
for(Inputout__c c:trigger.new)
{
name=c.Doctor_Name__c;
}
for(Dropoff1__c dp:d)
{
dp.Text__c=name;
}
update d;
}
===================================================================================
=======
6.limit reached the records
trigger SCENARIO6 on Account (before insert,before update) {
integer count=0;
list<account>a=[select id,name from account where createddate=today or lastmodifieddate=today];
for(account ac:trigger.new)
{
count=a.size();
ac.NumberofLocations__c=count;
if(count>2)
{
ac.adderror('reached limit today');
}
}
===================================================================================
===========
7.can not inser/update/delete that user account object records
trigger scenario30 on Account (before insert,before update,before delete) {
user u=[select id,name from user where username='
[email protected]'];
if(u.id==userinfo.getUserId())
{
if(trigger.isdelete)
{
for(account a:trigger.old)
{
a.adderror('cant delete record');
}
}
if(trigger.isupdate)
{
for(account b:trigger.new)
{
b.adderror('can not update');
}
}
if(trigger.isinsert)
{
for(account c:trigger.new)
{
c.adderror('can not insert');
}
}
}
}
===================================================================================
====================
8.already existing records display error message
trigger scenario8 on Contact (before insert) {
list<string>st=new list<string>();
for(contact c:trigger.new)
{
list<contact>a=[select id,name,Email,lastname from contact where Email=:c.Email];
if(a.size()>0)
{
c.Email.adderror('already existing');
}
}
for loop without query
======================
trigger duplicatetrigger on Inputout__c (before insert) {
set<string>s=new set<string>();
for(Inputout__c op:trigger.new)
{
s.add(op.Doctor_Name__c);
}
list<Inputout__c>d=[select id,Doctor_Name__c from Inputout__c where Doctor_Name__c=:s];
set<string>dupids=new set<string>();
for(Inputout__c don:d)
{
dupids.add(don.Doctor_Name__c);
}
for(Inputout__c c:trigger.new)
{
if(c.Doctor_Name__c!=null)
{
if(dupids.contains(c.Doctor_Name__c))
{
c.Doctor_Name__c.adderror('already existing record');
}
}
}
}
===================================================================================
=====
9. count of related contacts and accounts field display size
public class rollupsummery {
public static void increment(list<contact>con)
{
set<id>ids=new set<id>();
for(contact c:con)
{
ids.add(c.accountid);
}
list<account>a=[select id,name,NumberOfEmployees,(select id,lastname from contacts) from account where id
=:ids];
for(account ac:a)
{
ac.NumberOfEmployees=ac.contacts.size();
}
update a;
trigger:
========
trigger scenario11 on Contact (after insert) {
rollupsummery.increment(trigger.new);
}
===================================================================================
====
10. when ever opportunity stagename =closedwon automatically update the account field rating=hot
trigger scenario12 on Opportunity (after insert,after update) {
set<id>ids=new set<id>();
list<account>ac=new list<account>();
for(opportunity op:trigger.new)
{
ids.add(op.AccountId);
ac=[select id,name,rating from account where id=:ids];
if(op.StageName=='Closed won')
{
for(account a:ac)
{
a.Rating='hot';
}
update ac;
}
}
===============================================================================
11.when ever account name is naveen automatically update the contact all lastnames
trigger scenario13 on Account (after update) {
string names;
list<contact>c=[select id,lastname,firstname from contact where lastname=:names ];
for(account a:trigger.new)
{
names=a.name;
}
for(contact con:c)
{
con.lastname=names;
}
update c;
===================================================================================
====
12.when ever a opportunity created record amount field is calculated by account total field
trigger scenario21 on Opportunity (after insert,after update,after delete) {
set<id>ids=new set<id>();
map<id,opportunity>opp=new map<id,opportunity>();
Decimal oldVal;
Decimal newVal;
if(trigger.isinsert)
{
for(opportunity op:trigger.new)
{
ids.add(op.AccountId);
opp.put(op.AccountId, op);
}
list<account> acc=[select id,Total_Amount__c from account where id=:ids];
for(account a:acc)
{
if(a.Total_Amount__c==null )
{
a.Total_Amount__c=opp.get(a.Id).amount;
}
else
{
a.Total_Amount__c= a.Total_Amount__c+opp.get(a.Id).amount;
}
}
update acc;
}
if(trigger.isUpdate)
{
for(opportunity op:trigger.new)
{
ids.add(op.AccountId);
opp.put(op.AccountId, op);
newVal=op.Amount;
}
for(Opportunity ops:trigger.old){
oldVal=ops.Amount;
}
list<account> acc=[select id,Total_Amount__c from account where id=:ids];
for(account a:acc)
{
if(a.Total_Amount__c==null )
{
a.Total_Amount__c=opp.get(a.Id).amount;
}
else
{
a.Total_Amount__c= a.Total_Amount__c+opp.get(a.Id).amount-oldVal;
}
}
update acc;
}
}
}
===================================================================================
===================
13.when ever a create a lead object automatically converted account ,contact,opportunity
trigger scenario19 on Lead (after insert) {
list<account>acc=new list<account>();
list<contact>con=new list<contact>();
list<opportunity>op=new list<opportunity>();
for(lead l:trigger.new)
{
account a=new account();
a.Name=l.lastname;
a.Phone=l.Phone;
acc.add(a);
contact c=new contact();
c.LastName=l.Name;
con.add(c);
opportunity o=new opportunity();
o.Amount=l.AnnualRevenue;
o.CloseDate=system.today();
o.StageName='closed won';
op.add(o);
}
insert acc;
insert con;
insert op;
=================================================================================
14.when ever create a contact automatically update opprtunity fields
trigger scenario17 on Contact (after insert) {
list<opportunity>op=[select id,name,stagename,Description,amount from opportunity limit 50];
for(contact c:trigger.new){
for(opportunity o:op)
{
if(o.amount<5000||o.Amount==null)
{
o.amount=5000;
o.Name=o.Name+'Mr';
o.StageName='prospecting';
}
else{
o.Amount=o.Amount+1000;
o.Name=o.Name+'Dr';
}
update o;
}
}
}
==================================================================================
15. Whenever new account is created, its rating should be hot.
trigger AccTrig on Account (before insert) {
for (Account a:trigger.new){
a.rating = 'Hot';
}
}
==================================================================================
16. Make a Fax field mandatory in Account using trigger.
trigger AccTrig on Account (before insert) {
for (Account a:trigger.new){
if (a.fax == Null){
a.fax.addError('Fax field is mandatory');
}
}
}
==================================================================================
17. Whenever a new contact is created, prefix the firstname with Mr.
trigger Contrig on Contact (before insert) {
for (contact c:Trigger.new){
c.salutation = 'Mr';
}
}
==================================================================================
18. Prevent the insertion of an account, if you already have an account with the same name
(Prevent the insertion of a duplicate account).
trigger AccountDuplicate on Account (before insert)
{
Set<String> setName = new Set<String>();
For(Account acc : trigger.new)
{
setName.add(acc.name);
}
if(setName.size() > 0 )
{
List<Account> lstAccount = [select name ,id from account where name in :setName ];
Map<String ,Account> mapNameWiseAccount = new Map<String,Account>();
For(Account acc: lstAccount)
{
mapNameWiseAccount.put(acc.name ,acc);
}
For(Account acc : trigger.new)
{
if(mapNameWiseAccount.containsKey(acc.name))
{
acc.Name.addError('Name already Exist ');
}
}
}
}
==================================================================================
19. Whenever a new contact is inserted in the system, update the accounts phone field with the contacts phone field.
TRIGGER :
trigger contactTrigger on Contact (before insert, before update, before delete, after insert, after update, after d
elete, after undelete) {
if(trigger.isBefore ){
system.debug('I am before trigger ');
}
else if(trigger.isAfter){
system.debug('I am after trigger ');
if(trigger.isUpdate){
contactTriggerHandler.afterUpdateHelper(trigger.new);
}
}
HANDLER CLASS :
public class contactTriggerHandler {
public static void afterUpdateHelper(List<Contact> conList){
Set<Id> setId = new Set<Id>();
for(Contact con:conList){
setId.add(con.AccountId);
}
system.debug('setId ' + setId);
List<Account> accItemList = [Select Id, Name, Phone, (Select Id, FirstName, LastName, Phone, Accoun
tId From Contacts) From Account Where Id IN:setId];
for(Account a1:accItemList){
for(Contact c1:a1.Contacts){
if(c1.Phone !=null){
a1.Phone = c1.Phone;
update accItemList;
}
}
}
}
}
==================================================================================
20. Create a contact whenever a new account is created.
trigger AccTrig2 on Account (after insert) {
set<id> Accid = new set<id>();
list<Contact> ContList = new List<Contact>();
for (Account a:Trigger.new){
Accid.add(a.id);
contact c = new contact();
c.AccountId = a.id;
c.lastName = a.name;
c.phone = a.phone;
contList.add(c);
}
insert contList;
}
==================================================================================
21. Prevent to delete account if they have related opportunity
trigger DeleteAccountOpportunity1 on Account (before delete)
{
List<Opportunity> opp = [Select accountID from opportunity where accountid in :TRIGGER.OLD];
for(Account a : Trigger.OLD)
{
for(Opportunity o : Opp)
{
if(a.id == o.accountId)
{
a.addError('Account have Opportunity ,so you can not delete this Account');
}
}
}
}
==================================================================================
22. if account is not exist during creating record in contact object then create new account record ::HAVE DOU
BT NEED TO ASK
==================================================================================
23. Trigger will prevent the user to delete records from account
trigger test6 on Account (before delete) {
for (Account A:Trigger.old){
A.addError(' You can not delete the record, Please contact your Administartator');
}
}
==================================================================================
24. Prevent user from creating duplicate accounts with same name
trigger AccountDuplicate on Account (before insert)
{
Set<String> setName = new Set<String>();
For(Account acc : trigger.new)
{
setName.add(acc.name);
}
if(setName.size() > 0 )
{
List<Account> lstAccount = [select name ,id from account where name in :setName ];
Map<String ,Account> mapNameWiseAccount = new Map<String,Account>();
For(Account acc: lstAccount)
{
mapNameWiseAccount.put(acc.name ,acc);
}
For(Account acc : trigger.new)
{
if(mapNameWiseAccount.containsKey(acc.name))
{
acc.Name.addError('Name already Exist ');
}
}
}
}
==================================================================================
25. Add a prefix dr to all leads names whenever a record is updated or inserted
trigger Leadtrig on Lead (before insert, before update) {
for (Lead l:Trigger.new){
l.Firstname = 'Dr. ' + l.FirstName;
}
}
==================================================================================
26. Prevent user to delete contact which is associated with any account.
trigger TrigContact on Contact (before delete) {
for (contact c:Trigger.old){
if(c.AccountId != Null){
c.addError('Can not delete contact');
}
}
}
==================================================================================
27. Throw an error if phone number is not 10 dight of length
trigger AccTrig23 on Account (before insert, BEFORE UPDATE) {
for (Account a:Trigger.new){
if (a.phone.length() != 10){
a.phone.addError('Phone length is not 10');
}
}
}
==================================================================================
28. Whenever contact is created update status field from it's associate account
==================================================================================
29. Whenever new record is created in account object, before this record inserted in account object Account,
delete all contact records avilable with the same name
==================================================================================
30. when ever a record is inserted to the Account automatically inserted to the Contact
trigger SCENARIO1 on Account (after insert) {
list<contact> c=new list<contact>();
for(account a:trigger.new)
{
contact b = new contact();
b.LastName = a.Name;
b.AccountId = a.Id;
c.add(b);
}
insert c;
==================================================================================
31. when ever a create opportunity object record updated total opportunies and total amount in account object
trigger scenario24 on Opportunity (after insert) {
set<id> ids = new set<id>();
for(Opportunity op:trigger.new)
{
ids.add(op.accountid);
}
list<account>ac=[select Total_opportunities__c,Total_Amount__c,(select id,Amount from Opportunities ) fro
ma
ccount where id=:ids];
for(account a:ac)
{
a.Total_opportunities__c=a.opportunities.size();
decimal sum=0;
for(opportunity p:a.opportunities)
{
sum=sum+p.amount;
}
a.Total_Amount__c=sum;
}
update ac;
}
==================================================================================
32. can not inser/update/delete that user account object records
trigger AccountDuplicate on Account (before insert, before update, before delete){
for (Account a:Trigger.new){
a.addError('Need to contact Amin for access');
}
}
==================================================================================
33. whenever opportunity StageName = Closed Won automatically update the account field Rating = Hot
trigger updateAccountRating on opportunity (after insert, after update){
list<Id> accIds = new list<Id>();
list<Account> accounts = new list<account>();
for(opportunity o:trigger.new){
accIds.add(o.accountId);
}
for(account a:[select Id, Rating from account where Id IN :accIds]){
for(opportunity opp:trigger.new){
if(opp.stage=='closed won'){
a.Rating='hot';
accounts.add(a);
}
}
}
update accounts;
}
==================================================================================
34. name field is updated on account then put name field as name + Phone
trigger AccountDuplicate on Account (before update){
for (Account a:Trigger.new){
if (a.name != Trigger.oldMap.get(a.Id).name){
a.name = a.name + trigger.oldMap.get(a.id).phone;
}
}
}
==================================================================================
35.Whenever account is created with annual revenue more than 50000, then add Pranay mehare as contact Name ::
DONE (Check 50 k and insert contact )
trigger test5 on Account (before insert) {
list<Contact> ContList = new List<Contact>();
// set<Id> AccIdsSet = new Set<Id>();
for (Account Acc:Trigger.new){
if (Acc.AnnualRevenue > 50000){
Contact cont = new contact();
Cont.AccountId = Acc.Id;
Cont.Firstname = 'Pranay';
Cont.Lastname = 'Mehare';
ContList.add(Cont);
}
}
Insert ContList;
}
==================================================================================
36. Whenever Lead is created with lead Source as WEB then give rating as COLD otherwise HOT
trigger test56 on Lead (before insert) {
for (Lead l:Trigger.New){
if (l.leadSource == 'Web'){
l.Rating = 'Cold';
}
Else{
l.Rating = 'Hot';
}
}
}
==================================================================================
37. Prevent Account from deleting if it has 2 or more contacts..
trigger Account1 on Account (before Delete) {
set<Id> AccIds = new set<Id>();
Map<Id, Account> AccMap = new Map<Id, Account>(); // need to store map
for (Account A:Trigger.old){
AccIds.add(A.Id);
}
for (Account A:[SELECT Id, Name, (SELECT Id, Firstname, LastName FROM Contacts) FROM ACCOU
NT WHERE Id IN :AccIds]){
AccMap.put(A.Id, A);
}
for (Account A1:Trigger.Old){
if (AccMap.get(A1.id).contacts.Size() >= 2){
A1.addError('You Can not delete Account');
}
}
}
==================================================================================
38. While creating or updating Lead check whether Email is already there in existing contact , if it is there then thro
w an error.
//Unrelated Objects ::
trigger Lead1 on Lead (before insert, before update) {
map<string, contact> contMap = new map<string, contact>();
list<contact> contEmail = [SELECT Id, Email FROM Contact];
for (contact c:contEmail){
contMap.put(c.Email, c);
}
for (lead l:Trigger.new){
if ((l.email != null) && (trigger.isInsert || (l.email != Trigger.oldMap.get(l.Id).Email))){
if (contMap.containsKey(l.email)){
l.Email.addError('Email already exist');
}
}
}
}
==================================================================================
39. Whenever phone is modified on account object then update contact record with phone field (other phone with ol
d value and home phone with new value)
associated with account record.
trigger updatePhone on Account (after update) {
Set<Id> accIdSet = new Set<Id>();
for(Account acc : Trigger.New){
if(acc.Phone!=trigger.oldmap.get(acc.Id).Phone){
accIdSet.add(acc.Id);
}
}
list<contact> conlist = new list<contact>();
for(Contact con : [select Id,AccountId from Contact Where AccountId In : accIdSet]){
con.HomePhone=trigger.newmap.get(con.AccountId).Phone;
con.OtherPhone = trigger.oldmap.get(con.AccountId).Phone;
conlist.add(con);
}
update conlist;
==================================================================================
40. Counts number of contacts on Account using trigger (Create Lookup Summary field using Trigger)
Note : Object CONTACT [Very importatnt]
TRIGGER :
trigger ContCount on Contact (After Delete, After Insert, After Update, After Undelete) {
If (Trigger.isInsert || Trigger.isDelete || Trigger.isUpdate || Trigger.isUndelete){
CountContact.ContContacts (Trigger.New, Trigger.Old);
}
}
HANDLER CLASS :
Public class CountContact {
Public static void ContContacts (list<Contact> NewContact, List<Contact> oldContact){
set<id> ContAccIds = new set<Id>();
try{
if (NewContact != Null){
for (Contact con:newContact){
if(Con.AccountId != Null){
ContAccIds.add(con.AccountId);
}
}
}
if (oldContact != Null){
for (Contact con:oldContact){
if(Con.AccountId != Null){
ContAccIds.add(con.AccountId);
}
}
}
List<Account> AccList = [SELECT Id, ContCount__c, (SELECT Id FROM Contacts) FROM Accoun
t Where Id IN :ContAccIds];
if (AccList != Null){
for (Account AccValue:AccList){
accvalue.ContCount__c = accValue.Contacts.Size();
}
}
if(!AccList.isEmpty()){
update AccList;
}
}
Catch (Exception e){
System.debug ('Get Message' + e.getMessage());
}
}
}
==================================================================================
41. Recursion in Trigger
TRIGGER :
Trigger TrigCont on Contact (Before insert){
if (trigger.isinsert && Trigger.isBefore && CreateCont.isFirst ){ //TRIGGER WILL RUN A
FTER ISFRIST CHECK
CreateCont = false; //TO AVOID RECURSION
createCont.CreateConts(Trigger.New);
}
}
HANDLER :
Public class CreateCont{
public static Boolean isFirst = true; //TO AVOID RECURSION
public static void (List<Contact> conList) {
List<Contact> cList = new List<Contact> ();
for (Contact c: conList){
contact c = new Contact;
c.firstName = 'Recursive';
c.LastName = 'Trigger';
cList.add(c);
if (!cList.isEmpty()){
insert cList
}
}
}
==========================================================******************=========
==============================================
