How to create Dependent Dropdown for state and city?

[phpdon]

Hello,

Please anyone can give a simple example for creating Dependent Dropdown for my module contacts.I want to add state and corresponding their city.

I am using CE6.1.

I have go through Sugar_Developer_Guide_6.1.0 but not able to implement .I would not like to use devtoolkit.


Please suggest.

Regards

[jmertic]

You are looking at adding custom JS code in CE, which would call an AJAX request to pull in the correct data for those two fields.

[phpdon]

Hello,

I want to use like below

Dependent Dropdowns are dropdowns who‟s options change when the selected value in a trigger
dropdown changes. The metadata is defined in the vardefs and contains two major components, a
“trigger” id which is the name of the trigger dropdown field and a „visibility grid‟ that defines the set
of options available for each key in the trigger dropdown. For example, you could define a sub-
industry field in accounts whose available values depend on the industry field.
<?php
'sub_industry_c' => array(
'name'
=> 'sub_industry_c',
'type'
=> 'enum',
'options'
=> 'sub_industry_dom',
'visibility_grid'=> array(
'trigger' => 'industry',
'values'
=> array(
'Education' => array('primary', 'secondary', 'college'),
'Engineering' => array('mechanical', 'electrical', 'software'),
),
),
)

?>

Regards

[shyam007]

Hi all,

I also fetching same problem, means I am not able to create a Dependent Dropdown using "Sugar Logic" framework.

Please help us.

[dsuvankar]

Go through this link
http://www.sugarcrm.com/forums/showthread.php?t=71116

[Francescas]

In your example:

Hello,

I want to use like below

Dependent Dropdowns are dropdowns who‟s options change when the selected value in a trigger
dropdown changes. The metadata is defined in the vardefs and contains two major components, a
“trigger” id which is the name of the trigger dropdown field and a „visibility grid‟ that defines the set
of options available for each key in the trigger dropdown. For example, you could define a sub-
industry field in accounts whose available values depend on the industry field.
<?php
'sub_industry_c' => array(
'name'
=> 'sub_industry_c',
'type'
=> 'enum',
'options'
=> 'sub_industry_dom',
'visibility_grid'=> array(
'trigger' => 'industry',
'values'
=> array(
'Education' => array('primary', 'secondary', 'college'),
'Engineering' => array('mechanical', 'electrical', 'software'),
),
),
)

?>

Regards

Can one replace the list of values with an existing dropdown?

For example, I have:
Country dropdown, State dropdown (state_list_DD), and Province dropdown (province_list_DD) defined in Sugar via Studio

The idea is to do something like

$dictionary['addlo_Address_Locations']['fields']['address_state']=
array(
'name' => 'address_state',
'vname' => 'LBL_ADDRESS_STATE',
'type' => 'enum',
'visibility_grid' => array('trigger' => 'address_country',
'values' => array(
'CANADA' => 'province_list_DD',
'USA' => 'state_list_DD',
)
),
'comment' => 'The state or province used for the address',
'merge_filter' => 'enabled',
);
?>

Thanks,
Francesca

[rafael.q.g@hotmail.com]

I already implemented this functionality many times on sugar, and basicaly what I do is:
1. Create a java script function that read the current select option for "state".
2. Develop an external php page that returns a list of all cities based in a state passed as paramenter.
3. Develop a javascript function that access this external page passing as parameter the value of selected state, and also update the cities list.
4. Assign the function developed on step 3 to the onchange event of state field.

[andopes]

This can be easily implemented by DevToolKit.
You can find the link to project page at my signature.

Regards

[Shripad1988]

Hi rafael,
Well im facing problems in implementing this drop-down code.Could u please specify which files to change and what code should be written in that?Even send the javascript file which u mentioned showing a small example.

Thnxs,

Regards..

[juanmrs]

Hi rafael,
Well im facing problems in implementing this drop-down code.Could u please specify which files to change and what code should be written in that?Even send the javascript file which u mentioned showing a small example.

Thnxs,

Regards..

Hello, i am having troubles implementing devtoolkit, i have sugar Versión 5.5.0 (Build 6653)
i have installed devtoolkit, ,

At first i replaced edit.view, list and detail in MVC/view/view..., but i got errrors.

then i modify the actual files inserting the function, but module is not changing the dependant dropdowns..

could you plase provide information about changing edit.view.php in my case has function like predisplay, display.. etc..

thanks in advanced, i am folowing instructions from user guide.