Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Microsoft CRM 4.0: Add related Account to the Activity View

Posted on 2010-09-23
10
Medium Priority
?
790 Views
Last Modified: 2012-05-10
I would like the Account to appear on my Activity views.  When I try to add, I get options to add Regarding(Account) or Regarding(Contact) but using fields from these options do not return the Account of the contact listed on the Activity.

Is there some other way to add Account to All Activities (or any Activity view)?

Thanks
0
Comment
Question by:apollo7
  • 5
  • 5
10 Comments
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 33744751
If the activity is regarding a contact then if you change the Add Column record type to Regarding (Contact) then you can select Parent Customer from the list of fields.

But not all activities will be regarding a contact so for those activities this field will be blank.

Is this what you meant?
0
 
LVL 1

Author Comment

by:apollo7
ID: 33744923
Yes, this is exactly my problem.  Not all activities are regarding a contact (some are regarding an Account). also some contacts do not have a Parent Customer, then have a field called Potential Customer - do I need to add all potentials fields or is there another way?

Thanks
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 33745019
I don't think there is another way. Because the regarding field can be for so many different types of record you will need to add all potential fields thus giving you a view with loads of columns.

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:apollo7
ID: 33745042
OK, so is there a script or other way to hide null columns in a view?

Thanks
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 33745062
Not that I know of. I think that would be very difficult because it would only make sense to hide a column if all rows have no data in that column.

You might be better off creating a SQL Reporting Services report.
0
 
LVL 1

Author Comment

by:apollo7
ID: 33745114
That makes sense, however, the complaint by users is that they want to see Account when they login to the Workplace.

It may be a number of columns bunched together - can you tell me what appears in the default Regarding column that comes with the Activity view out of the box?

Thanks
0
 
LVL 30

Accepted Solution

by:
Feridun Kadir earned 2000 total points
ID: 33745145
The Regarding column in the activity views is simply whatever the activity record was linked to. If you open, say, a task activity form you will see the regarding field - similarly for the other activity types.

If a user tracks an Outlook item in CRM then they can optionally click on the Regarding button and decide which record to link the item to. This will show up in the Regarding field for the item and can be virtually any record type.
0
 
LVL 1

Author Comment

by:apollo7
ID: 33863175
Another question - is there a way to hide the word "Regarding" in the column view
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 33895527
No I don't think there is a way to hide the word "Regarding".

0
 
LVL 1

Author Closing Comment

by:apollo7
ID: 33932314
Thanks for the help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question