function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
miku1051miku1051 

help on trigger two records are inserted instead of one..???


trigger test on Lead (after insert) 
{
	
	 Set<ID> ls = new Set<ID> ();
	 for(Lead l:Trigger.new)
    {
 ls.add(l.id);  
    }
    
    List <Lead> lis=[Select Id,Name,Status,Email,Company,fax,FirstName,LastName from Lead where id in:ls];
   	List<Contact> con=[Select Id,Name ,Email_2__c,fax from Contact ];
   	List<Contact> lstContact = new List<Contact>();
   	    //List<Contact> cntem=[Select Id,Email_2__c from Contact where Email_2__c=:lis.Email];   
   
    
   	for(Lead ld:lis)
   	{
   		for(Contact cn:con)
   		{
   			if(ld.Email==cn.Email_2__c)
   			{
   				
   					//Trigger.new[0].addError('Email already exists');
   			}
   			
   			else if(ld.Email != cn.Email_2__c) 
   			{
   				
				
				
	   			Contact objC= new Contact();
				objC.FirstName=ld.FirstName;
				objC.LastName=ld.LastName;
				objC.RecordTypeName__c='Candidates';
				lstContact.add(objC);
					
   	}
   		
   		if(lstContact.size() > 0 )
		insert lstContact;
		   				
}

 My problem is when i insert a lead...2 contacts are inserted instead of one...can some tell me why this is happening...pl help...

Best Answer chosen by Admin (Salesforce Developers) 
b-Forceb-Force

It looks you are trying to create a contact when lead is inserted with validation on Email field

 

Below is trigger script for you, This will works for bulk data upload as well .

 

trigger test on Lead (after insert) 
{
	try
	{
		Set<String> setEmails = new Set<String>();
		Map<String, Contact> mapCons = new Map<String, Contact>();
		List<Contact> lstContact = new List<Contact>();
		
		List<Contact> lstCont = [Select Id, Name , Email_2__c from Contact where Email_2__c in : setEmails];
		for(Contact objC : lstCont)
		{
			mapCons.put(objC.Email_2__c, objC);
		}
		for(Lead ld : Trigger.new)
		{
			if(mapCons.containsKey(ld.Email))
			{
			//Contact exist in system show error.
			ld.addError('Contact exist in System with email address '+ ld.Email);
			}else
			{
					Contact objC= new Contact();
					objC.FirstName=ld.FirstName;
					objC.LastName=ld.LastName;
					objC.RecordTypeName__c='Candidates';
					lstContact.add(objC);
			}
		}
			
			if(lstContact.size() > 0 )
			insert lstContact;
	}catch(Exception ex)
	{
		Trigger.new[0].adderror('Error ----'+ ex.getMessage());
	}	
}

 

 

Thanks,

bForce

All Answers

b-Forceb-Force

It looks you are trying to create a contact when lead is inserted with validation on Email field

 

Below is trigger script for you, This will works for bulk data upload as well .

 

trigger test on Lead (after insert) 
{
	try
	{
		Set<String> setEmails = new Set<String>();
		Map<String, Contact> mapCons = new Map<String, Contact>();
		List<Contact> lstContact = new List<Contact>();
		
		List<Contact> lstCont = [Select Id, Name , Email_2__c from Contact where Email_2__c in : setEmails];
		for(Contact objC : lstCont)
		{
			mapCons.put(objC.Email_2__c, objC);
		}
		for(Lead ld : Trigger.new)
		{
			if(mapCons.containsKey(ld.Email))
			{
			//Contact exist in system show error.
			ld.addError('Contact exist in System with email address '+ ld.Email);
			}else
			{
					Contact objC= new Contact();
					objC.FirstName=ld.FirstName;
					objC.LastName=ld.LastName;
					objC.RecordTypeName__c='Candidates';
					lstContact.add(objC);
			}
		}
			
			if(lstContact.size() > 0 )
			insert lstContact;
	}catch(Exception ex)
	{
		Trigger.new[0].adderror('Error ----'+ ex.getMessage());
	}	
}

 

 

Thanks,

bForce

This was selected as the best answer
miku1051miku1051

Thanks b-Force.It works for me...thanks

 

:):)