-
How to prevent user to delete an account with an Opportunity in Salesforce?
How to prevent user to delete an account with Opportunity?
-
2 Replies
-
trigger DeleteAccountOpportunity1 on Account (before delete)
{
List Opp = [Select accountID from opportunity where accountid in :TRIGGER.OLD];
for(Account a : Trigger.OLD)
{
for(Opportunity o : Opp)
{
if(a.id == o.accountId)
{
a.addError('Account have Opportunity ,so you can not delete this Account');
}
}
}
} -
Hi Adarsh,
You can try this :-
trigger testDelete on Account (before delete)
{
List acc = [SELECT Id, (SELECT Id FROM Opportunities ) FROM Account WHERE Id IN : Trigger.old];
for(Account a : acc)
{
if(a.Opportunities.size()!=0)
{
a.addErrors('Cant Delete');
}
}
}
Log In to reply.
Popular Salesforce Blogs
Learn All About SOQL in Salesforce
SOQL SOQL is a language that extracts data from the Salesforce database. In Object-Oriented Programming for Admins you found that you can use Data Manipulation…
Salesforce Financial Services Cloud | Empower your borrowers with Mortgage Innovation
Loans and Mortgages are key elements of today’s economy and there is a likelihood that every adult at some time or other has been part…
Configure Salesforce SAML Single Sign-On in 2024
Configuring Salesforce SAML Single Sign-On (SSO) is a critical step in enhancing both the security and user experience within your organization. SAML (Security Assertion Markup…
Popular Salesforce Videos
Salesforce Tutorial - Creating Custom Object
Many times, New Salesforce Developers don’t understand from where to start it. In this video, I have shown the way exactly to create a Custom…
Salesforce App Builder Certification Questions Explained
CRM tools serve as the base for managing small and large-scale businesses, and Salesforce is among the best CRM tools in the industry. Therefore, Salesforce…
Get Started with Salesforce Elevate
Salesforce is a powerful tool to analyze your past fundraising, and monitor your ongoing efforts. In this webinar, we'll start with the fundamentals -- understanding…
