Please forgive me for absolute newbishness. Only have done couple of Visualforce pages for e-mail templates and some validation rules. Now I need to get this trigger done.
I need to have a custom field in Leads that has a count of Activities in Activity History. Usually I would do that with roll-up field, but it is not available in leads.
I found a trigger in these forums:
trigger Activity_count on Task (after insert, after update) {
List<Lead> uplist=new List<Lead>();
List<Lead> lelist=[select id,Activity_count__c from Lead];
List<AggregateResult> st=new List<AggregateResult>();
st=[select count(Id),whoid from task where id=:Trigger.new and status='Completed' group by whoid];
for(Integer i=0;i<st.size();i++)
{
for(Lead l:lelist)
{
if(l.id==st[i].get('whoid'))
{
l.Activity_count__c=(Integer)st[i].get('expr0')+l.Activity_count__c;
uplist.add(l);
}
}
}
update uplist;
}
But problem is that I get following error:
Average test coverage across all Apex Classes and Triggers is 0%, at least 75% test coverage is required.
What I am trying to accomplish (given all the SF EE and my skill limitations) is to pull up in a formula field for Account total Amount of only the 1st Closed Won opportunity associated with that account. It basically will tell sales folks (and provide data for reports) that shows how much customers usually spend the first time they buy.
So how do I write a condition that shows only the first "Closed Won" opportunity for the Account?
Under Contacts and Account for the Activities I have "Log A Call" and "Send An E-mail" buttons.
I need to re-do Log A Call button, so it does the same thing it does not, but it also needs to set a value in custom Activity picklist Activity_Type__c to "Spoke"
I also need to clone that button and create Log Voicemail, which would do the same thing as Log A Call, but set the custom Activity picklist Activity_Type__c to "LVM"
Lastly, is there any way to have "Send An E-mail" button to set the Activity custom picklist Activity_Type__c to "Emailed"? I can't see where to tweak that layout, since it does not show the picklist now.
I am doing this all to make it easier to track how my team is reaching out to our customers.
We have a business rule, that if 1st Opportunity created under the Account has a Primary Campaign Source set to a certain Campaign, then every opportunity after has to have save Primary Campaign Source.
Issue is, sales people forget to enter that, or don't bother looking it up, if they are in a rush.
So I need a trigger, that looks up 1st Opportunity under the Account (which is set to Type = New Business) and copies the Primary Campaign Source from that Opportunity, to any subsequent Opportunities under the same Account.
This is my first attempt at tweaking an APEX. It is a e-mail template for Invoice which is generated from "Send E-mail" within Opportunity. I am getting: " Error: Unknown property 'core.email.template.EmailTemplateComponentController.Opportunity' " when I am trying to save. What am I missing here?
This is my first attempt at tweaking an APEX. It is a e-mail template for Invoice which is generated from "Send E-mail" within Opportunity. I am getting: " Error: Unknown property 'core.email.template.EmailTemplateComponentController.Opportunity' " when I am trying to save. What am I missing here?
Please forgive me for absolute newbishness. Only have done couple of Visualforce pages for e-mail templates and some validation rules. Now I need to get this trigger done.
I need to have a custom field in Leads that has a count of Activities in Activity History. Usually I would do that with roll-up field, but it is not available in leads.
I found a trigger in these forums:
trigger Activity_count on Task (after insert, after update) {
List<Lead> uplist=new List<Lead>();
List<Lead> lelist=[select id,Activity_count__c from Lead];
List<AggregateResult> st=new List<AggregateResult>();
st=[select count(Id),whoid from task where id=:Trigger.new and status='Completed' group by whoid];
for(Integer i=0;i<st.size();i++)
{
for(Lead l:lelist)
{
if(l.id==st[i].get('whoid'))
{
l.Activity_count__c=(Integer)st[i].get('expr0')+l.Activity_count__c;
uplist.add(l);
}
}
}
update uplist;
}
But problem is that I get following error:
Average test coverage across all Apex Classes and Triggers is 0%, at least 75% test coverage is required.
What I am trying to accomplish (given all the SF EE and my skill limitations) is to pull up in a formula field for Account total Amount of only the 1st Closed Won opportunity associated with that account. It basically will tell sales folks (and provide data for reports) that shows how much customers usually spend the first time they buy.
So how do I write a condition that shows only the first "Closed Won" opportunity for the Account?
This is my first attempt at tweaking an APEX. It is a e-mail template for Invoice which is generated from "Send E-mail" within Opportunity. I am getting: " Error: Unknown property 'core.email.template.EmailTemplateComponentController.Opportunity' " when I am trying to save. What am I missing here?
