I'm attempting to restrict the delete of a Contact, via before delete trigger, by looking for a specific value in a custom picklist field.

I've created a trigger, as follows (on Before Delete):

trigger ContactDelete on Contact (before delete)
{
static string errSecPointContact = 'This Contact is the Security Point of Contact on the Account, and cannot be deleted. Please contact the SFDC Admin group for any questions.';
for (Contact c : trigger.old)
{
if (c.Job_Role__c == 'Security Point of Contact')
{
c.addError(errSecPointContact);
}
}
}

This error message displays as follows:

"Validation Errors While Saving Record(s)
There were custom validation error(s) encountered while saving the affected record(s). The first validation error encountered was "This Contact is the Security Point of Contact on the Account, and cannot be deleted. Please contact the SFDC Admin group for any questions.".

Click here to return to the previous page. "

That's a pretty ugly solution. How can I go about adding this error to the standard object detail page, or display this error in a more user-friendly way?

Thanks!

Hello,

I've been following 2 threads in an attempt to write a trigger that reassigns ownership of certain leads upon insert, then execute assignment rules for the ones not meeting that criteria:

http://boards.developerforce.com/t5/General-Development/Urgent-Lead-Assignment-Rule-Trigger-recursively-updates-itself/td-p/174995

- and -

http://boards.developerforce.com/t5/Apex-Code-Development/How-to-route-LEADs-back-through-LEAD-Assignment-rules/m-p/171285#M26391

The problem: this line in the trigger code:

lIds.add(l.Id);

 never seems to have an Id to add, so the assignment rules don't reassign anything. I may not have constructed this trigger correctly based on the example, so please let me know if you see something wrong with this.

Trigger code:

trigger LeadNamedAccountOwnership on Lead (before insert)
{
    List<Id> lIds = new List<id>();
    
    for (lead l : trigger.new)
    {
        // get lead email, lookup related domains
        if (l.Email != null && l.Email.length() > 0)
        {
            LeadCaseAssignment.leadAssignAlreadyCalled = LeadCaseAssignment.SetLeadOwnerByEmail(l);
        }
        if (!LeadCaseAssignment.leadAssignAlreadyCalled && l.IsConverted == false)
        {
            system.debug('leadId = ' + l.Id);
            lIds.add(l.Id);
        }
    }
    if (LeadCaseAssignment.leadAssignAlreadyCalled() == false)
    {
        LeadCaseAssignment.LeadAssign(lIds);
    }
}

 Helper class:

public with sharing class LeadCaseAssignment 
{
	public static Boolean leadAssignAlreadyCalled = false;

    public static boolean leadAssignAlreadyCalled()
    {
        return leadAssignAlreadyCalled;
    }
    
    @future
    public static void LeadAssign(List<Id> lIds)
    {
        leadAssignAlreadyCalled = true;
        
        List<Lead> leads = [   Select Id From Lead Where Id IN: lIds];

        for (lead l : leads)
        {
            Database.DMLOptions dmo = new Database.DMLOptions();
            dmo.assignmentRuleHeader.useDefaultRule= true;
            l.setOptions(dmo);
        }
        
        //try{
        update(leads);
        //}
    }

    public static boolean SetLeadOwnerByEmail(Lead lead)
    {
        List<Account> accounts = GetDomainAccounts(lead.Email);
        
        if (accounts.size() > 0)
        {
            if (accounts.get(0).Mid_Market_Named_Region__c != '' || accounts.get(0).US_Enterprise_Region__c != '')
            {
                lead.OwnerId = accounts.get(0).OwnerId;
                return true;
            }
        }

        return false;
    }
    
    private static List<Account> GetDomainAccounts(String email)
    {
        List<Domain__c> domains = new List<Domain__c>();
        List<Account> accts = new List<Account>();
        
        String emailDomain = email.split('@').get(1).trim();

        domains = [ Select Id, Account__c, Name 
                    From Domain__c 
                    Where Name =: emailDomain];
                    
        for (Domain__c domain : domains)
        {
            accts = [   Select a.US_Enterprise_Region__c, a.Mid_Market_Named_Region__c, a.Id, a.OwnerId 
                        From Account a 
                        Where Id =: domain.Account__c limit 1];
        }

        return accts;
    }

    static testMethod void testLeadCaseAssignment()
    {
    	Test.startTest();

        TestUtility util = new TestUtility();
        Account testAccount = util.getTestAccount();
        Contact testContact = util.getTestContact(testAccount);

        Domain__c domain = new Domain__c();
        domain.Account__c = testAccount.Id;
        domain.Name = 'test.com';
        insert domain;

        Lead testLead = util.getTestLead();
        testLead.Email = 'test@test.com';
        update testLead;
                
        system.assertEquals(true, LeadCaseAssignment.leadAssignAlreadyCalled());

        List<Id> ids = new List<Id>();
        ids.add(testLead.Id);
        LeadCaseAssignment.LeadAssign(ids);

        LeadCaseAssignment.SetLeadOwnerByEmail(testLead);
        
        testLead.Email = 'test@doink.com';
        update testLead;
        
        LeadCaseAssignment.SetLeadOwnerByEmail(testLead);

        Test.stopTest();
    }
}

Thanks in advance,

Brian

Hello,

I'm working on a project to allow conversion of Cases to Accounts, Contacts and Opportunities. From the default Lead Detail page, there's a convert button that opens the Lead Conversion page, which contains a combination drop-down, lookup and view control for Account Name. The Account Name dropdown is a fuzzy match on the Lead Account Name field, then allows either a lookup or a view of the selected Account.

Has anyone tried to replicate this set of controls for other objects? I'd like build the same control for Cases, but not sure where to start. Screenshot of the control in question attached.

Thanks,

Brian

Hello,

I've been following 2 threads in an attempt to write a trigger that reassigns ownership of certain leads upon insert, then execute assignment rules for the ones not meeting that criteria:

http://boards.developerforce.com/t5/General-Development/Urgent-Lead-Assignment-Rule-Trigger-recursively-updates-itself/td-p/174995

- and -

http://boards.developerforce.com/t5/Apex-Code-Development/How-to-route-LEADs-back-through-LEAD-Assignment-rules/m-p/171285#M26391

The problem: this line in the trigger code:

lIds.add(l.Id);

 never seems to have an Id to add, so the assignment rules don't reassign anything. I may not have constructed this trigger correctly based on the example, so please let me know if you see something wrong with this.

Trigger code:

trigger LeadNamedAccountOwnership on Lead (before insert)
{
    List<Id> lIds = new List<id>();
    
    for (lead l : trigger.new)
    {
        // get lead email, lookup related domains
        if (l.Email != null && l.Email.length() > 0)
        {
            LeadCaseAssignment.leadAssignAlreadyCalled = LeadCaseAssignment.SetLeadOwnerByEmail(l);
        }
        if (!LeadCaseAssignment.leadAssignAlreadyCalled && l.IsConverted == false)
        {
            system.debug('leadId = ' + l.Id);
            lIds.add(l.Id);
        }
    }
    if (LeadCaseAssignment.leadAssignAlreadyCalled() == false)
    {
        LeadCaseAssignment.LeadAssign(lIds);
    }
}

 Helper class:

public with sharing class LeadCaseAssignment 
{
	public static Boolean leadAssignAlreadyCalled = false;

    public static boolean leadAssignAlreadyCalled()
    {
        return leadAssignAlreadyCalled;
    }
    
    @future
    public static void LeadAssign(List<Id> lIds)
    {
        leadAssignAlreadyCalled = true;
        
        List<Lead> leads = [   Select Id From Lead Where Id IN: lIds];

        for (lead l : leads)
        {
            Database.DMLOptions dmo = new Database.DMLOptions();
            dmo.assignmentRuleHeader.useDefaultRule= true;
            l.setOptions(dmo);
        }
        
        //try{
        update(leads);
        //}
    }

    public static boolean SetLeadOwnerByEmail(Lead lead)
    {
        List<Account> accounts = GetDomainAccounts(lead.Email);
        
        if (accounts.size() > 0)
        {
            if (accounts.get(0).Mid_Market_Named_Region__c != '' || accounts.get(0).US_Enterprise_Region__c != '')
            {
                lead.OwnerId = accounts.get(0).OwnerId;
                return true;
            }
        }

        return false;
    }
    
    private static List<Account> GetDomainAccounts(String email)
    {
        List<Domain__c> domains = new List<Domain__c>();
        List<Account> accts = new List<Account>();
        
        String emailDomain = email.split('@').get(1).trim();

        domains = [ Select Id, Account__c, Name 
                    From Domain__c 
                    Where Name =: emailDomain];
                    
        for (Domain__c domain : domains)
        {
            accts = [   Select a.US_Enterprise_Region__c, a.Mid_Market_Named_Region__c, a.Id, a.OwnerId 
                        From Account a 
                        Where Id =: domain.Account__c limit 1];
        }

        return accts;
    }

    static testMethod void testLeadCaseAssignment()
    {
    	Test.startTest();

        TestUtility util = new TestUtility();
        Account testAccount = util.getTestAccount();
        Contact testContact = util.getTestContact(testAccount);

        Domain__c domain = new Domain__c();
        domain.Account__c = testAccount.Id;
        domain.Name = 'test.com';
        insert domain;

        Lead testLead = util.getTestLead();
        testLead.Email = 'test@test.com';
        update testLead;
                
        system.assertEquals(true, LeadCaseAssignment.leadAssignAlreadyCalled());

        List<Id> ids = new List<Id>();
        ids.add(testLead.Id);
        LeadCaseAssignment.LeadAssign(ids);

        LeadCaseAssignment.SetLeadOwnerByEmail(testLead);
        
        testLead.Email = 'test@doink.com';
        update testLead;
        
        LeadCaseAssignment.SetLeadOwnerByEmail(testLead);

        Test.stopTest();
    }
}

Thanks in advance,

Brian

I created a list button that opens a popup VF page which contains a form. After the form is saved, I want the popup to close and for the parent window to be refreshed. The refresh works great on FireFox and Chrome, but IE8 is somehow opening the parent window in a new window, instead of just refreshing the existing window. I've gone through various methods of opening a new window (window.showModalDialog, window.open, etc) and have settled on window.open() in my list button. I also found a great piece of code on the forum that returns values from my controller, closes my pop up and refreshes the parent window. 

Why is IE8 opening a new window instead of just refreshing the existing one?

List button javascript:

window.open('/apex/quickCreateProduction?id={!Contact.Id}',"window","width=460, height=375");

 Javascript in VF page (popup):

<script language="javascript" type="text/javascript">
if("{!$Request.success}" == "true") {
	parent.window.close();
	parent.window.opener.location.href = "/{!$Request.id}";          
}
</script>

Save in custom controller (after success):

		PageReference curPage = ApexPages.currentPage();
		curPage.getParameters().put('success','true');
		curPage.getParameters().put('id',Apexpages.currentPage().getParameters().get('id'));
		curPage.setRedirect(true);
		return curPage;

I could definitely use some help. Thanks in advance.

Adriel

Hi,

while working quite a lot with campaigns and opportunities, I'm faced with the problem to create campaign influence records for opportunities in batch (not manually)

Adding an influence for an contact or lead is quite easy; add a record to the table CampaignMember and that's it... 

But - in which table are records stored that define a relationship between an opportunity and a campaign? Can't find it - the prefix is 0BG - if this might help anybody.

Many thanks in advance!