Lesson: 29 | Prevent users to create an opportunity with an existing name

I am a User.

WHEN I want to create a New Opportunity AND there is already an Opportunity with the same name

THEN a validation error message should prevent me from doing this change.

ERROR MESSAGE: There is an Opportunity with the same Name. Try another name

Apex Trigger
Video

Apex Trigger

trigger OppTrigger on Opportunity (before insert) {
    List<Opportunity> oppList =[SELECT Id, Name FROM Opportunity WHERE Name =:Trigger.new[0].Name];
    if(oppList.size()!=0){
        Trigger.new[0].Name.addError('There is an Opportunity with the same Name. Try another name');
    }
}

Prev You need to login to have access to the quizzes. MARK THIS AS UNDERSTOOD Next

Mastered by 24 users.

Exercises

A. Administrator | Exercises (59 lessons)

B. Flow Builder | Exercises (41 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (90 lessons)

E. Integration | Exercises (4 lessons)

F. Lightning Web Component (LWC) Exercises (14 lessons)

Go to top

Login to your account

Lesson: 29 | Prevent users to create an opportunity with an existing name

Apex Trigger

Exercises