Please help Add phone number to activity list view

[pmisner]

Hi,
I'd like some help adding a phone number from the contact on the activity list view. Ultimately, I want to have all the calls, contacts names, and people who I want to call in a nice list. I tried to do this with the module editor, but couldn't figure how to get a field from another database table into the list.

[mikael.kindborg]

Hi,
I'm looking into doing the same thing, did you succeed in adding phone fields to the view?
Best, Mikel Kindborg

[andopes]

Hi all

You need to perform the following steps:

1. Add the field definition for the fields coming from related modules (contact phone number etc) into vardefs. You need to add the attribute 'source' => 'non-db',
2. Create a logic_hook process_record to fill into this fields the appropriate value.

There are threads discussing how to do that.

Cheers

[mikael.kindborg]

Many thanks indeed. I will look into these steps. I get the idea of having a hook to pull data from the other table.

[mikael.kindborg]

Hi all.

I have now written extension code that use the process_record hook to display phone numbers in custom fields in the Contact list. I also wrote an article that describes how to do this. It can be found here: http://www.msc.se/teknikhornan/artik...-sugarcrm.html

Please let me know if you have any ideas for improvements, I'm new to SugarCRM, so I might have misunderstood some of the aspects involved. However, since I found little documentation in this area, I decided to write an article about it.

Many thanks and best regards, Micke