Dependent Drop Downs
Feb 11, 2005Many companies require dependent drop downs for things like case categorization. There’s a neat trick using that Graham Rowe came up with leveraging scontrols, an enterprise edition feature. Attached are details on how to set it up along with screenshots. Keep in mind this requires some technical knowledge to execute.
Download dependent_drop_downs.PDF
Download double_drop_down_example.txt
Download triple_drop_down_example.txt
Bookmark
Create an scontrol (see file triple dropdown example.txt)
Didn't see any sforce control in this text?????
Posted by: Alan Collins | February 24, 2005 at 06:40 PM
See the source of the 3 files attached
Posted by: Yvan Poulin | February 25, 2005 at 10:58 AM
I solved a couple of problems I had when a category had no sub category entries, but I'm having trouble solving a problem with the "Update Case Record" function. When I click the "Save" button, nothing happens. I am getting a status value back from the server of 500 rather than 200.
Anyone have a solution?
Anyone have another version of this double/triple dropdown for opportunities (or a list of chnages to make it work for opportunities)?
Posted by: Tim Hensler | April 21, 2005 at 09:28 AM
Tim,
Double check the created custom fields on the case entity 'Category' and 'Sub category'. This technique utilises the API and currently needs EE to be run.
Next step if still failing is to look at the HTTP response. Add an alert after the xmlhttp.Send:
alert(xmlhttp.responseText);
Regards,
Graham
Posted by: | May 09, 2005 at 03:54 AM
This is great, any instructions on how it is done perhaps?
Posted by: Niclas | June 16, 2005 at 10:13 AM
This is a great example of developing dependent fields in an SControl.
Do you have any examples of how to populate the values in Category, Sub Category, and Item in the Sforce Control from the existing Case? So if the case has these values already, then is there a way to default the same values in the Sforce Control?
Posted by: Adam Getz | July 29, 2005 at 08:06 AM
Will this help with product pricing?
We have categories of price associated with each product entered for an opportunity. Examples are Hosting Service, Implementation Service, Maintenance, etc. that are unique to the Product. I don't want to have to set up each one of these in a long list with the Products as this would make the selection list at least 5 times as long, and trouble for the sales rep to enter. These sub-categories need to roll up into the Product and opportunity total.
Posted by: Bob Gumaer | August 02, 2005 at 07:00 AM