Return details from Module B to Module A

[jvcampbell]

Hi

I'm new to sugarcrm, and am busy with the community edition.

I've created a module that holds info.

I want to include this information in the opportunities module.

So if I've entered my Opportunities information, and I select a name/key value from my Custom Module, then it should return all the linked information and bind it too the Opportunity.

I'm struggling to get this relatively easy (in theory) thing working .

I've been looking at the referenced fields and module relationships, but I'm feeling like I'm bungling around in the dark.

[andopes]

Let us know what kind of information would you like to copy from Custom Module to Opportunities.

Cheers

[jvcampbell]

Hi

I've got a module of properties.
It would have a property code (the key).
Then it would have info like no_bathrooms, no_bedrooms, property_type, estimate_value, estimate_date etc.

So on the opportunity form, the user should be allowed to select the property code, and all the property information related to that property should be visible on the form.

Thanks,
J

[andopes]

Thsi may fit your needs.
Add a code like that into Propery Field def at editviewdefs.php:

             'displayParams' => 
            array (
              'field_to_name_array' => array(
                'id' => 'accounts_tenyaccounts_ida',
                'name' => 'accounts_test_company_name',
                'billing_address_street' => 'billing_address_street',
                'billing_address_city' => 'billing_address_city',
                'billing_address_state' => 'billing_address_state',
                'billing_address_country' => 'billing_address_country',
                'billing_address_postalcode' => 'billing_address_postalcode',
                'website' => 'website',
                'phone_office' => 'phone_office',
                'phone_fax' => 'phone_fax',
                'phone_alternate' => 'phone_alternate',
                'employees' => 'employees',
                'annual_revenue' => 'annual_revenue',
                'industry' => 'industry',
                'account_type' => 'account_type',
              ),
              'additionalFields' => array(
                'website' => 'website',
                'phone_office' => 'phone_office',
                'phone_fax' => 'phone_fax',
                'phone_alternate' => 'phone_alternate',
                'employees' => 'employees',
                'annual_revenue' => 'annual_revenue',
                'industry' => 'industry',
                'account_type' => 'account_type',
              ),
            ), 
  

In this code the left side field is the source field (Property module) and the right side field is the target field.
Obviously update it with your fields.

Cheers

[jvcampbell]

Thanks for your quick response!

Can the application not handle this kind of thing?

Is custom dev the only way to get it done?

[andopes]

This is a customization you must accomplish by hand.

Regards

[z3r0]

Sorry,

if i bring up this old thread, but i have the same problem. This code

 'displayParams' => 
            array (
              'field_to_name_array' => array( 
                'id' => 'keycm_moduleb_id_c', 
                'name' => 'customfielda_c',
                'description' => 'customfield2a_c',
              ),
              'additionalFields' => array( 
                'description' => 'customfield2a_c',
                ),
            ), 
  

works but if change description to text ('text' is an ohter field in module B) this don't work, i don't understand this.
don't work:

 'displayParams' => 
            array (
              'field_to_name_array' => array( 
                'id' => 'keycm_moduleb_id_c', 
                'name' => 'customfielda_c',
                'text' => 'customfield2a_c',
              ),
              'additionalFields' => array( 
                'text' => 'customfield2a_c',
                ),
            ), 
  

and no it is not text_c because i create this module and load it with the moduleloader, so "text" is a column in database.

hoping for ideas...

Edit: the solution is the last post of leowolff, see
http://www.sugarcrm.com/forums/showthread.php?t=48165

ps.: FAQ is terrible, I want sugar wiki !