New field in popup window

[fbrites]

Hi.
I have SugarCRM 5.0.0e in Windows XP.

I created a new module with the subpanel 'Accounts'. In this subpanel, when I do select, I want the popup window appears the field 'Type' (account_type).
As I do this?
I tried to change the file <root>/ modules/Accounts/metadata/popupdefs.php: (changes are in bold)

global $mod_strings;

$popupMeta = array('moduleMain' => 'Account',
	'varName' => 'ACCOUNT',
	'orderBy' => 'name',
	'whereClauses' => 
	array('name' => 'accounts.name', 
	'billing_address_city' => 'accounts.billing_address_city',
	'phone_office' => 'accounts.phone_office'),
        'account_type' => 'accounts.account_type'),
'searchInputs' =>
	array('name', 'billing_address_city', 'phone_office', 'account_type'),
	'create' =>
	array('formBase' => 'AccountFormBase.php',
	'formBaseClass' => 'AccountFormBase',
	'getFormBodyParams' => array('','','AccountSave'),
	'createButton' => $mod_strings['LNK_NEW_ACCOUNT']
		  ),
'listviewdefs' => array(
	'NAME' => array(
	width' => '40', 
	'label' => 'LBL_LIST_ACCOUNT_NAME', 
	'link' => true,	
	'default' => true,								        
	 ), 
	'BILLING_ADDRESS_STREET' => array(
	'width' => '10', 
	'label' => 'LBL_BILLING_ADDRESS_STREET',
	'default' => false,										        
	),
	'BILLING_ADDRESS_CITY' => array(
	'width' => '10', 
	'label' => 'LBL_LIST_CITY',
	'default' => true,										        
	),
	'BILLING_ADDRESS_STATE' => array(
	'width' => '7', 
	'label' => 'LBL_STATE',
	'default' => true,									        	
	),
	'BILLING_ADDRESS_POSTALCODE' => array(
	'width' => '10', 
	'label' => 'LBL_BILLING_ADDRESS_POSTALCODE',
	'default' => false,										        
	),
	'BILLING_ADDRESS_COUNTRY' => array(
	'width' => '10', 
	'label' => 'LBL_COUNTRY',
	'default' => true,
	 ),
	'PHONE_OFFICE' => array(
	'width' => '10', 
	'label' => 'LBL_LIST_PHONE',
	'default' => false),			
	 ),						     
	'ASSIGNED_USER_NAME' => array(
	'width' => '2', 
	'label' => 'LBL_LIST_ASSIGNED_USER',
        'default' => true,
	 ),
        'ACCOUNT_TYPE' => array(
	'width' => '10', 
	'label' => 'LBL_TYPE',
	'default' => true,
        ),
),
'searchdefs'   => array(
'name', 
'billing_address_city', 
'billing_address_state',
'billing_address_country',
]'account_type',
array('name' => 'assigned_user_id', 'label'=>'LBL_ASSIGNED_TO', 'type' => 'enum', 'function' => array('name' => 'get_user_array', 'params' => array(false))),
										  )
						);

These changes will add the column 'Type' in the 'Account List'.
the next link shows what I do: http://www.dibconsulting.com/sites/images/image2.jpg
What should I do? Someone can help me?
Thank you

[kuske]

I think you must edit the popup_picker.html to add this field.

[fbrites]

Thanks Kuske.

I'll try to do the file popup_picker.html.
You can give me an example how I do to file popup_picker.html for the 'account_type'?

Thenks

[bstonehill]

I just did this yesterday.

Are you trying to add a search field or list field?

To add a search field add this code under the advanced search array in modules/module_name/metadata/searchdefs.php.

10 => 
array (
     'name' => 'field_name',
     'label' => 'LBL_FIELD_NAME',
     'type' => 'field_type',
),

Note: replace the number (10) with the next unused number. It's okay to skip numbers but you can't have any numbers without an entry or you will get a white screen on the popup.

Likewise to remove a field comment out or remove an entry including the number.

The list fields should be the same as you setup the listview layout in studio.

Hope this helps!

[fbrites]

Thanks bstonehill...

I had succeeded! After I repair with admin user in SugarCRM and now exists in the field popup.

Thanks

[xamremy]

Hi guys,

I'd like to do the same thing as fbrites.
The solution from bstonehill doesn't seem to be working.
fbrites, could send the code from your popupdefs.php after repair please ? or explain more clearly what you have done ?
Thanks for helping.

[fbrites]

Hello xamremy

In my case it worked. I created the 'account_type' in the popup window.

This is my file 'popupdefs.php' with changes (<root>/ modules/Accounts/metadata/popupdefs.ph)

 global $mod_strings;
 
$popupMeta = array('moduleMain' => 'Account',
                        'varName' => 'ACCOUNT',
                        'orderBy' => 'name',
                        'whereClauses' => 
                            array('name' => 'accounts.name', 
                                    'billing_address_city' => 'accounts.billing_address_city',
                                    'phone_office' => 'accounts.phone_office',
                                    'account_type' => 'accounts.account_type'),
                        'searchInputs' =>
                            array('name', 'billing_address_city', 'phone_office', 'account_type'),
                        'create' =>
                            array('formBase' => 'AccountFormBase.php',
                                    'formBaseClass' => 'AccountFormBase',
                                    'getFormBodyParams' => array('','','AccountSave'),
                                    'createButton' => $mod_strings['LNK_NEW_ACCOUNT']
                                  ),
                        'listviewdefs' => array(
                                            'NAME' => array(
                                                'width' => '40', 
                                                'label' => 'LBL_LIST_ACCOUNT_NAME', 
                                                'link' => true,    
                                                'default' => true,                                        
                                                ), 
                                            'BILLING_ADDRESS_STREET' => array(
                                                'width' => '10', 
                                                'label' => 'LBL_BILLING_ADDRESS_STREET',
                                                'default' => false,                                                
                                                ),
                                            'BILLING_ADDRESS_CITY' => array(
                                                'width' => '10', 
                                                'label' => 'LBL_LIST_CITY',
                                                'default' => true,                                                
                                                ),
                                            'BILLING_ADDRESS_STATE' => array(
                                                'width' => '7', 
                                                'label' => 'LBL_STATE',
                                                'default' => true,                                                
                                                ),
                                            'BILLING_ADDRESS_POSTALCODE' => array(
                                                'width' => '10', 
                                                'label' => 'LBL_BILLING_ADDRESS_POSTALCODE',
                                                'default' => false,                                                
                                                ),
                                            'BILLING_ADDRESS_COUNTRY' => array(
                                                'width' => '10', 
                                                'label' => 'LBL_COUNTRY',
                                                'default' => true,
                                                ),
                                            'ACCOUNT_TYPE' => array(
                                                'width' => '10', 
                                                'label' => 'LBL_TYPE',
                                                'default' => true,
                                                ),
                                             'PHONE_OFFICE' => array(
                                                'width' => '10', 
                                                'label' => 'LBL_LIST_PHONE',
                                                'default' => false),                                         
                                            'ASSIGNED_USER_NAME' => array(
                                                'width' => '2', 
                                                'label' => 'LBL_LIST_ASSIGNED_USER',
                                                'default' => true,
                                               ),
                                            ),
                        'searchdefs'   => array(
                                             'name', 
                                            'billing_address_city',
                                            'billing_address_state',
                                            'billing_address_country',
                                            array('name' => 'assigned_user_id', 'label'=>'LBL_ASSIGNED_TO', 'type' => 'enum', 'function' => array('name' => 'get_user_array', 'params' => array(false))),
                                            'account_type',
                                          )
                        );
?> 
 

After go to admin -> repair -> quick repair -> module 'accounts'

This image of the popup window: http://www.dibconsulting.com/sites/i...opup_final.jpg

Hasta

[fbrites]

xamremy done well?

[xamremy]

it worked fine for me.

Thanks !

[fbrites]

Good.

More some help says.

Hasta

Fábio