How to turn a text field into a drop down

[buckalec]

HI - new to sugar and hit a bit of a wall.

How can I edit the data type for "Title;" and "Department" from text field to be drop downs?

I've also created custom new drop downs but don't seem to be able to edit the layout in the "Create Contact" from inside accounts

Any help would be really appreciated

thanks
james

[chad.hutchins]

if you want to change a custom field from one type to another, you will need to find the record for the field in the fields_meta_data table. You can search by field name to find the right field record. You will change the type from 'text' to 'enum'.

[andopes]

Hi, james

You can create an extended vardefs for the module.
Supposing you are talking about the Contacts module in the SugarCRM CE 5.0.0x version.

1. Create the file custom/Extension/modules/Contacts/Ext/Vardefs/vardefs.ext.php
2. Create an array which modify the type of the field and defines the option

 $dictionary['Contact']['fields']['department']['type'] = 'enum';
$dictionary['Contact']['fields']['department']['options'] = 'department_dom'; 
  

After that you have to Rebuild Extensions

Cheers

[chad.hutchins]

Thanks andopes!

Your solution is much better!

I am curious, Sugar Hero, do you know if using my method would have caused other things in my system to break? I have used it on several custom fields that I have wanted to edit.

Thanks

[richarddixonfl]

Quick question, I have a custom field named contract_purchaser_c in Leads, It was originally created as a Text box and has values in it. We have created a dropdown with the purchasers in it called dom_contract_purchasers and I have gone into LeadVarDefs.php within cache (since there is no mention of the field in vardefs.php under /modules/leads/) and have removed / readded the field in studio and deployed the views. I am now seeing a dropdown instead of a textfield, and see the appropriate values in the dropdown. the problem lies in that it is not showing the value that is set for that field in the database. If I select the correct value in edit view and save, it will then show up. It seems like the dropdown works but is not showing what is in the database until you resave it with the correct value. Is there a specific repair function that i should perform to make whats in the db show up in the field? (Also went into the fields_meta_data table in SQL and adjusted it accordingly just like any other enum field)

Here is the section in leadvardefs.php that refers to the field:

'contract_purchaser_c' =>
array (
'required' => 0,
'source' => 'custom_fields',
'name' => 'contract_purchaser_c',
'vname' => 'LBL_CONTRACT_PURCHASER',
'type' => 'enum',
'massupdate' => 0,
'default' => '-blank-',
'comments' => '',
'help' => '',
'importable' => 'true',
'duplicate_merge' => 'enabled',
'duplicate_merge_dom_value' => '1',
'audited' => 1,
'reportable' => 1,
'len' => 100,
'options' => 'dom_contract_purchasers',
'studio' => 'visible',
'id' => 'Leadscontract_purchaser_c',
'custom_module' => 'Leads',
),


ANY Ideas?

[WEB11]

I used the code mentioned above to change the Subject field in the Cases module to a drop down list. This is what added under custom/Extension/modules/Cases/Ext/Vardefs/vardefs.ext.php

<?php 

$dictionary['Case']['fields']['name']['type'] = 'enum';
$dictionary['Case']['fields']['name']['options'] = 'a_problem_cat_list';
 
?>

Thanks for the help André

[dskanth]

Hello, iam new to Sugar and facing a problem with the implementation of dynamic drop down.
My requirement is that: i have a drop down box, under Accounts.
And i need to populate this dropdown with the fields from a module called Clinics.
Please advice. Your help is much appreciated.

[letrium]

Hello!

Try to use 'function' definition in defs files.

http://www.sugarcrm.com/forums/showt...491#post145491

Cheers,

[prasannagowri]

hello i am new to sugar and i have a doubt regarding the Shortcuts.
How to remove the Shortcuts panel in the top left side from a module ?
Please suggest a solution. Help is much appreciated

[letrium]

hello i am new to sugar and i have a doubt regarding the Shortcuts.
How to remove the Shortcuts panel in the top left side from a module ?
Please suggest a solution. Help is much appreciated

Please create your own thread.