Related module field in Subpanel

[ericwindham]

Hi all,

I am having trouble with a client request.

We use the 'Contacts' module as our customer module. The Contacts module has a one-to-many relationship with the 'Opportunities' module.

Our client wants a Contacts subpanel that also has fields from the most recently created related Opportunity. So it would look something like the following:

Contact.Name         Contact.Email          Opportunity.some_field           Opportunity.some_other_field

Does anyone know how to do this?

[rafael.q.g@hotmail.com]

On subpanel each field is rendered by a "widget".
A possible way to do that is to create a widget for each fiield you want to have and program teh code to retrieve and write that.
Here is where widhets are coded:
include/generic/SugarWidgets/*.*

You could get based in some existing one to make yours.

[ericwindham]

Thanks for the response

I've tried that and the following:

array (
    'name' => 'monthly_payment',
    'vname' => 'LBL_MONTHLY_PAYMENT',
    'type' => 'varchar',
    'function' => array('name'=>'getMonthlyPayment', 'returns'=>'html', 'include'=>'custom/modules/Contacts/ContactsOpFields.php'),
    'len' => '10',
    'source' => 'non-db',
    'studio' => 'visible',
    'comment' => 'What is this customers monthly payment, if available'
)

With this version, I can add the field to the Detail View, but it will not show in the subpanel. It's just an empty field in the subpanel.