How do I display values coming from 2 fields (similar to "Name")

[Pepin]

Hello!

I noticed that in the Detail View of the Contacts module, SugarCRM combines the Last and First Name fields.

How do I do this for other fields?

Currently, I added fields for Japanese Last and First Name which are displayed separately in the Detail View. I want to be able to do the same thing as the default view, except it should display "Last Name First Name".

Thanks!

[crmbalah]

Hi
try to write 'customCode' in detailviewdefs.php.

[andopes]

Hello!

I noticed that in the Detail View of the Contacts module, SugarCRM combines the Last and First Name fields.

How do I do this for other fields?

Currently, I added fields for Japanese Last and First Name which are displayed separately in the Detail View. I want to be able to do the same thing as the default view, except it should display "Last Name First Name".

Thanks!

Hi Pepin

Have a look at the cache/modules/Contacts/ContactVardefs.php

     'name' => 
    array (
      'name' => 'name',
      'rname' => 'name',
      'vname' => 'LBL_NAME',
      'type' => 'name',
      'fields' => 
      array (
        0 => 'first_name',
        1 => 'last_name',
      ),
      'sort_on' => 'last_name',
      'source' => 'non-db',
      'group' => 'last_name',
      'len' => '255',
      'db_concat_fields' => 
      array (
        0 => 'first_name',
        1 => 'last_name',
      ),
      'importable' => 'false',
    ), 
  

You can write some extended vardefs to do the same for your fields.
Remember rebuilding extensions just after generating the extended vardefs.

Cheers

[Pepin]

Hi guys!

Thanks for the info!

[Pepin]

Hi Andre!

We tried the above codes. When we tried rebuilding the extensions, the file gets overwritten and reverted back to the original.

Are we correct in using the "rebuild" found in the Repair of the Admin section? Or are we supposed to edit a different file?

Sorry, we're really quite new to these.

Thanks for the help.

[andopes]

Let us know both file name and content you had created/modified.

Cheers

[Pepin]

Hello!

We've created the following fields in Contacts.
a. Japanese First Name - jp_first_name_c
b. Japanese Last Name - jp_last_name_c
c. Japanese Name - the plan is to show this as a combination of "jp_first_name_c + jp_last_name_c"

We've copied the portion found in the ContactVardefs.php and came up with the following:

'japanese_name_c' =>
array (
'name' => 'japanese_name_c',
'rname' => 'japanese_name_c',
'vname' => 'LBL_JAPANESE_NAME',
'type' => 'name',
'fields' =>
array (
0 => 'jp_first_name_c',
1 => 'jp_last_name_c',
),
'sort_on' => 'jp_last_name_c',
'source' => 'non-db',
'group' => 'jp_last_name_c',
'len' => '255',
'db_concat_fields' =>
array (
0 => 'jp_first_name_c',
1 => 'jp_last_name_c',
),
'importable' => 'false',
),


Now, we're confused as to where we should place this set of codes. We tried updating the same file. But after rebuilding, the codes get returned to the original.

Thanks for all your help.

[andopes]

Hi Pepin

My suggestion is to create an extended vardefs for this purpose.
You need to create the folders and file custom/Extension/modules/Contacts/Ext/Vardefs/vardefs.ext.php

The content should looks like that:

 $dictionary['Contact']['fields']['japanese_name'] = array(
      'name' => 'japanese_name',
      'rname' => 'japanese_name',
      'vname' => 'LBL_JAPANESE_NAME',
      'type' => 'name',
      'fields' => 
      array (
        0 => 'jp_first_name_c'',
        1 => 'jp_last_name_c'',
      ),
      'sort_on' => 'last_name',
      'source' => 'non-db',
      'group' => 'last_name',
      'len' => '255',
      'db_concat_fields' => 
      array (
        0 => 'jp_first_name_c'',
        1 => 'jp_last_name_c'',
      ),
      'importable' => 'false',
); 
  

Go to Admin -> Repair -> Rebuild Extensions

Cheers

[Pepin]

Thanks so much!

I'll update again after we try this out.

[Pepin]

Hi Andre!

We were able to proceed with the rebuilding.

After rebuilding, we noticed that the japanese_name_c field that we originally created disappeared. Is this normal.

Our problem now is how to add the janapese_name_c field into the layouts.

Thanks in advance!