Hey guys, today in this post we are going to learn about How can we prevent duplicate name insert on custom object in Salesforce.
Real time scenarios:- Write a trigger on custom object When a Object (childObjTrigger__c) is being created, if a record exists with the same EmployeeName (EmployeeName__c), the trigger should throw an error.
Create a custom object with custom field name as EmployeeName
Custom Object:- childObjTrigger__c >> custom field:- EmployeeName__c (Text
type)
- Don’t forget to check out:- Trigger to update count of child records with custom field of parent object Click Here For More Information
Files we used in this post example:-
| childTriggerhandler.apxt | Apex Class Trigger | It is used for prevent duplicate record creation with same name |
| childObjHandler.apxc | Apex Class Handler | It is call into cildTriggerhandler.apxt file. |
|
Custom Child Object:- childObjTrigger__c Custom Field:- EmployeeName__c |
Custom Child Object with Custom Field | It is custom object with custom field used for display an error if same name being inserted. |
You can download file directly from github by click here
Final Output
Other related post that would you like to learn in Salesforce
Step 1:- Apex Class Trigger : childTriggerhandler.apxt
From Developer Console >> File >> New >> Apex Trigger
childTriggerhandler.apxt [Apex Class Trigger]
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
trigger childObjTriggerHandler on childObjTrigger__c (before insert, after insert) { if(trigger.isBefore){ if(trigger.isInsert){ system.debug('I am inside before insert'); childObjHandler.childDuplicate(trigger.new); } } else if(trigger.isAfter){ if(trigger.isInsert){ //system.debug('I am inside after insert'); system.debug('Record inserted successfully'); } } } |
Step 2:- Apex Class : childObjHandler.apxc
From Developer Console >> File >> New >> Apex Class
childObjHandler.apxc [Apex Class Handler]
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
public class childObjHandler { //Do not allow duplicate Employee name public static void childDuplicate(List<childObjTrigger__c> dupChildRec){ Set<String> empExtStr = new Set<String>(); List<childObjTrigger__c> empList = [Select Id, Name, EmployeeName__c, childLookup__c, Status__c From childObjTrigger__c where EmployeeName__c !=null]; for(childObjTrigger__c empStr:empList){ empExtStr.add(empStr.EmployeeName__c); } for(childObjTrigger__c childTr:dupChildRec){ if(empExtStr.contains(childTr.EmployeeName__c)){ childTr.EmployeeName__c.addError('Do not allow duplicate'); } } } } |
Further post that would you like to learn in Salesforce
What is Apex trigger in Salesforce?
Apex triggers enable you to perform custom actions before or after events to records in Salesforce, such as insertions, updates, or deletions. Just like database systems support triggers, Apex provides trigger support for managing records.
What is the use of Apex triggers?
Apex triggers enable you to perform custom actions before or after changes to Salesforce records, such as insertions, updates, or deletions. A trigger is Apex code that executes before or after the following types of operations: insert. update.
What is the difference between Apex and trigger in Salesforce?
Classes consist of other classes, user-defined methods, variables, exception types, and static initialization code A trigger is Apex code that executes before or after specific data manipulation language (DML) events occur, such as before object records are inserted into the database, or after records have been deleted.
Related Topics | You May Also Like
Create Duplicate Rule & Matching Rule to Prevent Insert/Update Duplicate Records on Contact sObject based on Contact Email and Contact Phone in Salesforce | preventing duplicate records of contact based on multiple fields phone and email help by admins in Salesforce
Write a trigger on Contact to Prevent the user to create duplicate Contact based on Phone if Phone number is already exist on related account in Salesforce | Apex trigger on Contact do not allow to create duplicate contact based Phone number if the contact with same phone exists in related account in Salesforce
Apex trigger on Account to avoid creation of duplicate record if the account with same phone exists in the system in Salesforce | Write a trigger on Account to Prevent the user to create duplicate Account based on Phone if Phone number is already exist in Salesforce
Write a trigger on lead to prevent duplicate records based on lead email Whenever the records is inserted Or updated using apex class handler trigger in Salesforce | How to prevent duplicate lead records based on email in apex trigger Salesforce
How to Avoid Duplicate Name Record Simply Using a Apex Controller Method and Validating a Lightning Input Form with Email Regex Pattern Checked and Submit Form on Click Button in Salesforce Lightning | How to prevent duplicate name record simply using a apex controller method
Create rollup summary using Apex trigger on custom object | rollup summary trigger for count of child records on custom object in Salesforce example
Trigger to Update the Custom Last Modified Date Field in the Parent Object When the Records in the Child Object is Updated Using Apex Trigger in Salesforce | How to get the last modified date of a custom object in apex trigger
Trigger to update parent records field when child record is updated | update parent field from child using apex trigger
- Your reaction of the article ▾
Author of w3web.net
Hi, I am a senior software developer and working in MNC company from more than 8 years. I am great fan of technology, configuration, customization & development. Apart of this, I love to write about Blogging in spare time, Working on Mobile & Web application development, Salesforce lightning, Salesforce LWC and Salesforce Integration development in full time. [Read full bio] | | The Sitemap where you can find all published post on w3web.net
Trigger is a important topic
good article
I like your article because Trigger is very important topic these days, Please keep sharing
You’re a beautiful inspiration. It really helps me in any situation. Where I stuck. Many of my friends told me to comment there post but I stuck what I should comment. Finally I got your post it always help me. Thanks for the lovely post.
Nice Blog
Nice Content