custom dropdown based on query

[jeffreyvsmith]

Wanting to create a dropdown that contains the results of a sql query. For example, I want a dropdown of users that just selects usernames that are in the database or select contacts that are in the database. Will this work or does the content of a dropdown have to be text in the en_us.lang.php file?

If a sql query cannot be used, what can I use to auto update the php file? Is this a job for sed/awk/cron or something. Any thoughts?

SugarCRM 4.0.0
PHP 5.1.6
MySQL 5.0.27
FC6 2.6.22.4-45.fc6

[eggsurplus]

Why not use the select boxes that are used to assign a user to a record on the detail pages? There are contact ones as well. It would take some custom coding to do however. Or are you trying to associate more than one user with a record? Would need to use subpanels then.

[mabechard]

Hi,

If I must have a dropdown because we want that into ours interface (you know designer...) ? How should I do? I need to fill a dropdown from a “mysql” table with id,value I try to modified the “enum” box type …. But it doesn’t work.

Marc-Andre Giroux

[JeanetteRoss]

I am interested in this too.
What a drop down or select box based on a previous field entry/select box
i.e.
Tasks
Pick Related to accounts - pick account
Pick Contact only belonging to the account picked

[mabechard]

This is my solution in sugar code :

#1 : Change vardefs.php

'support_term' =>
array (
'name' => 'support_term',
'vname' => 'LBL_SUPPORT_TERM',
'type' => 'varchar',
'len' => '25',
'function'=>array('name'=>'getSupportTerms', 'returns'=>'html', 'include'=>'modules/ProductTemplates/ProductTemplate.php'),
'comment' => 'Term (length) of support contract'
),

then add the function :

function getSupportTerms($focus, $field='support_term', $value,$view='DetailView') {
if($view == 'EditView') {
$html = "<select id=\"$field\" name=\"$field\">";
global $app_list_strings;
$the_term_dom = $app_list_strings['support_term_dom'];
array_unshift($the_term_dom,'');
$html .= get_select_options_with_id($the_term_dom,$focus->support_term);
$html .= "</select>";
return $html;
}

return $focus->support_term;
}

then add the fields on all files needed for the UI

then modifie this code :

function getMyDropDown($focus, $field='myproduct', $value,$view='DetailView') {
if($view == 'EditView') {
$html = "<select id=\"$field\" name=\"$field\">";
$html = get_mysql_value($focus->support_term)
$html .= "</select>";
return $html; //return my dropdown
}

return $focus->myproduct; //return view value
}

change :

'myproduct' =>
array (
'name' => 'myproduct',
'vname' => 'LBL_PRODUCT',
'type' => 'varchar',
'len' => '25',
'function'=>array('name'=>getMyDropDown, 'returns'=>'html', 'include'=>'modules/mymodule/mymodules.php'),
'comment' => 'My Product',
),

[mabechard]

I forgot to add the javascript :

$html = "<select id=\"$field\" name=\"$field\" onchange=\"DoSomeCode()\">";

[Momin]

Hi, i have been working to create a dynamic dropdown as alike as told in the above lines. em a very new to sugar.
Can you guide me a bit more on this? also if you could refer me some place, books, articles which can be helpful in development.