Skip to main content
Lowly Admin here who doesn't know Apex... I need to count the number of Activities (Tasks and Events) associated with the Lead that were logged by CURRENT lead owner. I want the total to appear in a field on the Lead object called Times_contacted_by_owner. Would any of you gracious developers be willing to help me with the trigger?
4 Antworten
  1. 11. Sept. 2020, 16:08

    You can refer  the following two triggers:

    trigger TaskTrigger on Task (after insert,after delete) {

        List<Id> leadIds = new List<Id>();

        if (trigger.isInsert) {

            for (Task task : trigger.new){

                if (task.whoId !=null && string.valueOf(task.whoId).startsWith('00Q')) {

                    leadIds.add(task.whoId);

                }

            }

        } else if (trigger.isDelete) {

            for (Task task : trigger.old){

                if (task.whoId !=null && string.valueOf(task.whoId).startsWith('00Q')) {

                    leadIds.add(task.whoId);

                }

            }

        }

        

        

        if (leadIds.size() > 0){

            Map<Id,Lead> leadMap = new Map<Id,Lead>();

            

            List<Lead> leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from events) from lead where Id in :leadIds];

            

            for (Lead lead : leads) {

                Integer count = 0;

                for (Event event : lead.events) {

                    if (event.ownerId == lead.OwnerId) {

                        count ++;

                    }

                }

                

                lead.Times_contacted_by_owner__c = count;

                leadMap.put(lead.Id,lead);

            }

            leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from tasks) from lead where Id in :leadIds];

            for (Lead lead : leads) {

                Integer count = 0;

                for (Task task : lead.tasks) {

                    if (task.ownerId == lead.OwnerId) {

                        count ++;

                    }

                }

                if (leadMap.containsKey(lead.Id))

                {

                    Lead l = leadMap.get(lead.Id);

                    l.Times_contacted_by_owner__c += count;

                    leadMap.put(lead.Id,l);

                }

                else

                {

                    lead.Times_contacted_by_owner__c = count;

                    leadMap.put(lead.Id,lead);

                }

            }

            update leadMap.values();

        }

    }

     

    trigger EventTrigger on Event (after insert,after delete) {

    List<Id> leadIds = new List<Id>();

    if (trigger.isInsert) {

    for (Event event : trigger.new){

    if (event.whoId !=null && string.valueOf(event.whoId).startsWith('00Q')) {

    leadIds.add(event.whoId);

    }

    }

    } else if (trigger.isDelete) {

    for (Event event : trigger.old){

    if (event.whoId !=null && string.valueOf(event.whoId).startsWith('00Q')) {

    leadIds.add(event.whoId);

    }

    }

    }

    if (leadIds.size() > 0){

    Map<Id,Lead> leadMap = new Map<Id,Lead>();

    List<Lead> leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from events) from lead where Id in :leadIds];

    for (Lead lead : leads) {

    Integer count = 0;

    for (Event event : lead.events) {

    if (event.ownerId == lead.OwnerId) {

    count ++;

    }

    }

    lead.Times_contacted_by_owner__c = count;

    leadMap.put(lead.Id,lead);

    }

    leads = [select id, Times_contacted_by_owner__c,ownerId,(select id,ownerId,subject from tasks) from lead where Id in :leadIds];

    for (Lead lead : leads) {

    Integer count = 0;

    for (Task task : lead.tasks) {

    if (task.ownerId == lead.OwnerId) {

    count ++;

    }

    }

    if (leadMap.containsKey(lead.Id))

    {

    Lead l = leadMap.get(lead.Id);

    l.Times_contacted_by_owner__c += count;

    leadMap.put(lead.Id,l);

    }

    else

    {

    lead.Times_contacted_by_owner__c = count;

    leadMap.put(lead.Id,lead);

    }

    }

    update leadMap.values();

    }

    }