Sharepoint 2007: populate drop down list 2 based on drop down listbox1 selection
I have two dropdowns. I would like to populate dropdown 2 based on the selection in dropdown 1. Can you tell me if this is possible in sharepoint 2007. Both dropdowns are populated from the database.
I created my own list containing both dropdowns.
Any help would be much appreciated.
Thank,
source to share
By default, this is not possible in SharePoint because SharePoint does not give you multidisciplinary validation or rules.
Apart from the calculated fields, you can pretty much consider all fields as having no knowledge of other fields.
However, if you are confident that your users will use the web interface for most of their work, then you can use the open source SHUIE (SharePoint User Interface Extender) to achieve what you want.
ShUIE is here: http://shuie.codeplex.com/
It is basically a small utility that allows you to load JavaScript that is inserted into SharePoint pages that meet some criteria. Oh, and you'll get jQuery too.
So, in your case "some criteria" is the list that contains your 2 x SELECT lists.
And you also define the page mode "NEW" and "EDIT" as these are two pages that have a form.
Then you just write a little piece of jQuery code to say, "If both of these fields exist, set the event to SELECT # 1 so that when the selected value changes, you update / filter the available parameters to SELECT # 2."
What is it.
So, you have a little code to write, but if you like JavaScript, it's not that bad.
Disclaimer: I wrote ShUIE ... but then this is exactly the script I wrote for it.
SharePoint Cascading Drop Down List (With Filter) Field type - Project provides you with dependent dropdown lists.
source to share