Lesson: 28 | Avoid deletion of the account with a contact

I am a User.

WHEN I want to delete an Account that has a Contact

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

Apex Trigger
Video

Apex Trigger

trigger AccountTrigger on Account (before delete) {
    List<Contact> relatedContacts =[SELECT AccountId FROM Contact WHERE AccountId IN: Trigger.oldMap.keySet()];
    for(Contact con : relatedContacts){
        Trigger.oldMap.get(con.AccountId).addError('You can not delete an Account with a Contact');
    }
}

Prev You need to login to have access to the quizzes. This lesson has already been completed by you. Next

Mastered by 30 users.

Exercises

A. Administrator | Exercises (62 lessons)

B. Flow Builder | Exercises (79 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (97 lessons)

01 | Sum of the numbers from 1 to 10

02 | Create 100 Accounts

03 | School Grading

04 | Max Integer

05 | Create a Lead Trigger that updates the value of Rating

06 | Create a trigger which updates the description of the related opportunities of an account...

07 | Update Description when an Account is created or updated

08 | Update Account's Billing Country as USA for America or AMERICA values

10 | Automatically Copy Mailing Address to Other Address When "Mailing Address Is Same As Other...

100 | Automatically Adjust Opportunity Close Dates Based on a Custom Range

101 | Scheduled Batch Update for Account Annual Revenue

102 | Update Account Ratings Based on Closed Case Count

103 | Preventing Multiple Open Cases for an Account

11 | Create List With Method and Parameters

12 | Set Lead Source to Web Upon Opportunity Creation or Update

13 | Automatically Set Opportunity Lead Source and Type

14 | Mandatory Type Field for Opportunities

15 | Student Management System

16 | Account Name Validation on Creation

17 | Unique Email

18 | Account Name can not be changed

19 | Concatenate two fields

20 | Update billing country to USA if entered as America

21 | Create a trigger that determines if the account name has changed

22 | Create a contact related to Account if Create Contact Field is Checked

23 | Update the description of the related opportunities of an account

24 | Prevents users to delete Accounts with related opportunities

25 | Create an Opportunity related to Account Object

26 | Update Annual Revenue

27 | Prevents users to change Stage Name of Won and Lost Opportunities

28 | Avoid deletion of the account with a contact

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

30 | Future Method Example 01

31 | Future Method Example 02

32 | Apex Scheduler Example

33 | Update Contact Description Upon Insertion or Update

34 | Prevent Deletion of Closed Won Opportunities

35 | Create Opportunity On Lead Conversion

36 | Batch Apex | Delete Records

37 | Batch Apex | Update Records

38 | Implementing a Stateful Batch Apex to Aggregate Data

39 | Batch Apex | Inactive Account Deleter

40 | UpdateAccountBillingAddress

41 | Delete Inactive Accounts

42 | Send New Year Message

43 | Debug the number of Deleted Accounts

44 | Update description when the Name of an Account is updated

47 | Update Phone Number of the Contacts when an Account is updated

48 | Prevent Duplicate Contact Creation

49 | Animal Sound Simulator

50 | Prevent Account Deletion

51 | Updating Last Contact Date on Account When Contacts Are Added or Updated in Salesforce

52 | Automatically Set Case Status and Priority for Email-Originated Cases

53 | Automatically Set Lead Rating Based on LeadSource

54 | Automatically Create Associated Contact Record for New Account

55 | Automatically Create Associated Contact Record for New Consulting Account

56 | Automatically Create Multiple Contact Records Based on Number of Contacts Specified on Account...

57 | Update Account with Latest Opportunity Amount

58 | Update Opportunity Stages on Account Deactivation

59 | Prevent Deletion of Active Accounts

60 | Restrict Editing of Closed Opportunities

61 | Validation rule to require Closed Lost Reason on Opportunities

62 | Restrict Account deletion to System Administrators only

63 | Prevent Deletion of Closed Opportunities

65 | Update Contact Owner When Account Owner Changes

66 | Preventing Duplicate Contact Records Trigger

67 | Deleting secondary contacts with a batch apex class

68 | Account Trigger for Updating Related Contacts

69 | Auto-assign Task to Case Owner

70 | Email Alert for High Priority Cases

71 | Notify User on Info Modification

72 | Schedule a daily Apex job to notify users on company holidays

73 | Prevent creation of new Account records outside of business hours

74 | Phone Number Formatting

75 | Vehicle Inventory Management

76 | Expense Tracking Application

77 | Set default value for Opportunity Type field as New Customer when left blank

78 | Constructor Example

79 | Interface Class

80 | Interface Class

81 | Random Stage Name Generator

82 | Deactivate System Administrator after 30 days inactivity

83 | Eliminate Duplicate Integers from a List

84 | Switch | Date Utility - Convert Month Name to Number

85 | Switch | Shipping Cost Calculator

86 | Empowering Account Owners in Salesforce

87 | Update Account Annual Revenue Based on Opportunity Amount Summaries

88 | Update Account Contacts Summary Fields

89 | Automated Phone Number Retrieval and Case Creation for Accounts with Missing Phone Information

90 | Update fields when an Account is created.

91 | Automated Test Data Entry

94 | Create Person Account for Each Contact

95 | Prevent Duplicate Contacts in the System

96 | Convert 24-Hour Time to 12-Hour Format

97 | Account Merge Utility

98 | Create Duplicate Accounts Dynamically Based on Existing Records

99 | Create Apex Method to Validate and Shorten String Length

E. Integration | Exercises (6 lessons)

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

Lesson: 28 | Avoid deletion of the account with a contact

Apex Trigger

Exercises

Login to your account