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
satyamsatyam 

How to write a trigger to check the duplicate record based on field

Hi,

 

I have a requirement is that

 

I have a field name as 'Job Name' where i filles engineer in one record now if user again creating the record where job name is engineer then its should show error massage that one record with same job name is allready exist.

 

So any idea how i can write a trigger for this.

 

Thanks in Advance:))))

ShamilShamil

Check out this recipe: http://developer.force.com/cookbook/recipe/preventing-duplicate-records-from-saving
Anu Raj.ax1269Anu Raj.ax1269

write a trigger on before update and query the object with the condition.

 

this is hoe to send a message to a vf page.

ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR, ' Your Message');
ApexPages.addMessage(myMsg);