+ Start a Discussion
Dutta SouravDutta Sourav 

Calculating Activity Score on Task & Event

My Requirement is:
There is custom field "Activity Score" on Contact and Account, which should be updated based on following formula:

Contact/Account Activity Score =
Count of Meetings * 3 + Count of calls * 2 + Count of Emails * 1

(Note: This count will be done for all child activities)

Can anyone help??
SonamSonam (Salesforce Developers) 
You will have to create triggers on both task and event objects such that you can count the number of meetings/mails and calls made for a specific contact and account.

Sample codes available on the following links:
https://developer.salesforce.com/forums/ForumsMain?id=906F000000092b1IAA
https://developer.salesforce.com/forums/ForumsMain?id=906F000000092cGIAQ
Pranav Mandlik 16Pranav Mandlik 16
i am having the same problem what will be the solution