Creating Custom Charts ~ Phone Call Duration


Microsoft Dynamics CRM 2011 has got exciting new features that help you create custom charts in a few clicks while you are accessing your records. You then see the custom chart as you view your records.

clip_image002

The out of the box entity “phone call” allows us to create a custom chart. The default setting is to show a call duration in minutes. Let’s have look at the how can we create the chart by duration specifying by number of hours.

1. Go to customization è Customize the system

2. Go to Forms

3. Open main form

4. Add fields

clip_image003

5. Now we have a custom field called “new_durationinhours” and I have kept the display name as “Duration(In Hours)”.

6. Add that field on your form

clip_image004

7. You will notice we already have Duration field OOTB, where the schema name is “actualdurationinminutes”

clip_image005

8. Click on the field; select “Change Properties” in the ribbon. Select Event Tab

9. You will the below screen

clip_image006

10. In the form libraries, Click “Add”. You will see a lookup on web resources

clip_image007

11. In the bottom, Click “New”

12. Add the required information, as below

clip_image009

13. Save the record.

14. Add your Jscript code in the Text Editor

15. I have provided the source code below:

clip_image011

16. Save and publish the record

17. You will automatically be taken to Lookup Screen back, with the name entered for the library

clip_image012

18. Click Ok. You’re library is added to the form.

19. Now in the Event handlers, Click “Add”.

clip_image013

20. Once you click add, you will need to mention the function that you’re going to call.

clip_image014

21. Click OK

22. Save and publish the changes on the form.

23. Now go to Phone call form in customizations (Step 1 – 3)

24. Repeat the steps from (7 – 9)

25. You will see the script library

26. Go to Activities, select Phone call

27. You will Phone call activities listed

28. Create a chart and use that custom field as below in the screen shot.

clip_image016

With this simple walkthrough I hope I have not only shown you how easy it is to create a customized chart. I hope it will give you ideas for other kinds of customization that will make your implementation of Microsoft Dynamics CRM more powerful and useful.

Cheers,

Apurv Ghai


Comments (1)

  1. RX says:

    Good one!