Convert text field to a drop-down

[andromeda9]

I would like to convert the rating field in Accounts to a drop-down in order to restrict what is entered into this field. There are several approaches in the forums so I am wondering what is the preferred way to do this.

Thanks for the help in advance.

[andopes]

Hi Andromeda

Write this code into custom/Extension/modules/Accounts/Ext/Vardefs/vardefs.ext.php

 <?php
$dictionary['Account']['fields']['rating']['type'] = 'enum';
$dictionary['Account']['fields']['rating']['options'] = 'dropdown_name';
?>  

Create the folders and file.
Obviously update the dropdown_name to the appropriate dropdown name for rating.
Got to Admin -> Repair -> Quick Repair and Rebuild

Cheers

[terencelhl]

Hi Andromeda

Write this code into custom/Extension/modules/Accounts/Ext/Vardefs/vardefs.ext.php

 <?php
$dictionary['Account']['fields']['rating']['type'] = 'enum';
$dictionary['Account']['fields']['rating']['options'] = 'dropdown_name';
?>  

Create the folders and file.
Obviously update the dropdown_name to the appropriate dropdown name for rating.
Got to Admin -> Repair -> Quick Repair and Rebuild

Cheers

Hi Andopes,

Thank you for the quick solution. Cheers.

[judgej]

This worked a treat for me too.

I did also need to "save and deploy" the basic and advanced search forms that had this field on, in order to change the search form field from the original text field to the dropdown. The "quick repair and rebuild" did not update that area. There may be another rebuild option that I'm not spotting.

-- Jason

[rafael.q.g@hotmail.com]

Please check if this field has its type overwritten for some of theses layouts. Look for some code as 'type'=>'<any type>'

[pacasum.repocusin]

Thanks for this! I also tried to do a manual code edit. Here it is:

1.) Go to custom\modulebuilder\packages\<module_name>\module s\<my_mod>\vardefs.php
2.) Search the code of the field to be changed.

     'city' => 
    array (
      'required' => true,
      'name' => 'city',
      'vname' => 'LBL_CITY',
      'type' => 'varchar',
      'massupdate' => 0,
      'comments' => '',
      'help' => '',
      'importable' => 'true',
      'duplicate_merge' => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited' => false,
      'reportable' => true,
      'len' => '20',
      'size' => '20',
    ), 
  

3.) Change 'type' => 'varchar' to 'type' => 'enum'.

4.) Add the ff properties to make it as a dropdown.

       'options' => 'dropdown_list',
      'studio' => 'visible',
      'dependency' => false, 
  

5.) Go to module builder and press save.

[climbing-alien]

Is it possible to do this as a module/extension that can be installed though the module loader? Running 6.3 through Sugar ondemand and I have no access to the file system.

Thanks in advance!

[Angel]

It is certainly possible. Simply create the file locally and then use the copy feature of the Module Loader package manifesto to copy it to the appropriate location on the remote file system.

It would be similar to this technique:

Angel's Blog: Logic Hooks: OnDemand Installations