Forum Discussion
Cascading Drop Down Lists in SharePoint
Hello,
A easy way is following this blog post : http://spjsblog.com/2013/08/20/convert-text-fields-to-cascading-dropdowns-unlimited-number-of-levels/
You can download it from here: http://spjsfiles.com/SharePoint%20JavaScripts/CascadingDropdowns_v3/v3.525/spjs_casc_v3.525.zip
No need to create multiple lists, only one list and it's easy.
Sample:
<script language="javascript" src="/SiteAssets/JS/SPJS/SPJS-Casc_min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
spjs.casc.init({
lookupList:"ListToLookAT",
lookupListFields:["Title","Title1"],
thisListFields:["Title","Title1"],
dropDownDefaultvalue:"select",
hideEmptyDropdowns:true,
autoselectSingleOption:true,
clearInvalidSelection:true,
debug:false
});
});
</script>
Thanks,
Catalin.
Wonder if you can help me with this
I am trying to make this cascade look up work for me on Sharepoint Lists.
I have a main list called registration.
I also have 3 lists called Employee, Courses and Categories.
Course List has columns: Course, category, Course ID, Date, etc
Categories List has one columns, category
Employees Field has Fields : Department, Employee ID, Employee Name etc
From the Registration List, when I Select a category, In the drop down I only want to select a course, on the courseID field
When I Select a Department, from the Employee List, I only want to see Employees in that department in the Employee ID field
When I Select a course, I only want to choose dates for that course
I have seen the codes above, but I am having a hard time making it to work.
Any help will be greatly appreciated.
I would recommend using PowerApps to create a custom form, here is an example https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Cascading-dropdowns-for-single-line-of-text/ba-p/22927 from DaR0GaE1
