Newbie - Missing something obvious

[RLJB]

Hi All

I've been using the module builder and studio to see what is possible without delving into code.

I seem to be missing something obvious, in a newly created module I simply want to display/show a field from another module

I have tried the following:
1. Say there is a field for a mobile phone number called "phone_mobile" in an existing module called "contacts"
2. I want to use this in a new module that I built using module builder called "performance"
3. I use studio, open the fields in "performance"
4. Click add field and add new text field called "phone_mobile" with all the same properties (eg phone field, 25 chars, etc) as the "phone_mobile" field in the "contacts" module

It just creates the field but calls it "phone_mobile_c" - which it treats as a new and seperate field.

I have tried using 1:1 relationship but I can only ever get the primary field to display ie "name"

Surely you can display a field from another module using the studio/builder? What am I not understanding here?

Thanks

RLJB.

OS = Windows Vista
Suagar = Version 5.1.0b (Build 4905) Community Edition
Apache / PHP / MySQL as installed by the fast stack installation

[andopes]

Hi RLJB

Using Module Builder you can create a new module, this you already know perfectly.
Using Studio you can modify the existing modules (built in modules and custom modules), in an upgrade safe way the Studio create new fields into <table_name>_cstm table and the fields has the suffix '_c' to indicate this is a custom field. That is what is happening in your system.

Let me understand your needs:
You want to automatically copy the field phone_mobile from Contact to Performance module when selecting a Contact from the Relate field into Performance module.
Right?

If this is your needs so do the following:

1. Edit the file cache/modules/Contacts/Contactvardefs.php
2. Copy the phone_mobile definition from this file to modules/Performance/vardefs.php
3. Copy the language entry for phone_mobile in the cache/modules/Contacts/language/<your_language>.lang.php to modules/Performance/language/<your_language>.lang.php
4. Go to Admin -> Repair -> Rebuild Extension / Repair Database
5. Edit the modules/Performance/metadata/editviewdefs.php and add this new definition at the end of the relate field to Contacts:

             'displayParams' =>
            array (
              'field_to_name_array' => array(
                'id' => '<id_field_of_contact>',
                'name' => '<name_field_of_contact>',
                'phone_mobile' => 'phone_mobile',
              ),
              'additionalFields' => array(
                'phone_mobile' => 'phone_mobile',
              ),
            ), 
  

Replace the <id_field_of_contact> and <name_field_of_contact> by the properly values.

Regards

[SugarDev.net]

nice andopes.

Is this documented somewhere?

[andopes]

Yes, in my mind!



I'm trying to get a precious free time to document some tricks I know.
I have developed some good javascript tools to customize easily SugarCRM and I want to share it to community, but my free time had been focused on my wedding planning.
Almost there, in January I'll get married!

[eggsurplus]

Congrats Andopes! Hopefully you won't be bringing Sugar with you on your honeymoon!

[andopes]

If I talk about Sugar on Honey Moon my wife certainly will kill me!

[RLJB]

Thanks Andre - I will give it a go and report back on my success.