Sep 07 2016 06:07 AM
Hi all,
is anyone know a better way (with no coding is better ...) to have cascading drop down lists in sharepoint online like this : http://www.markrackley.net/2014/05/20/cascading-drop-down-lists-in-sharepoint-office-365-using-rest/
merci !
Sep 07 2016 06:49 AM
There is a way of doing this using Infopath and Sharepoint Designer, see link below -
Sep 07 2016 07:01 AM
Thanks for answering
Forms editing with infopath are not supported for all licence in sharepoint online ... so I havre to find a solution without this tool ...
Sep 07 2016 07:02 AM
Sep 07 2016 07:39 AM
Sep 07 2016 10:56 PM
i guess if you do not want to use infopath due to license problems which is kind of strange as you can use web viewer and only need to create the form with another account.
but then you could look at a possible solution with powerapps & Flow.
Kr,
Paul
Sep 08 2016 12:16 AM
Sep 08 2016 12:57 AM
Juan Carlos,
what would you use instead?
Sep 09 2016 07:08 AM
This is one of the most frustrating things for us in SharePoint Online, too. All of the people who ask for forms want this, and they can't do it themselves, even as power users. It needs client-side code, and then the IT department gets involved in creation and maintenance of every form. We are also avoiding InfoPath, and waiting for a better solution from Microsoft.
Sep 09 2016 07:46 AM
Sep 09 2016 09:51 AM
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.
Sep 13 2016 06:58 AM
Sep 13 2016 07:48 AM
Sep 13 2016 07:56 AM
Especially with a small IT staff. No way for a small team to keep up with requests and then maintain them, too.
Mar 21 2018 10:49 AM
Mar 22 2018 02:37 AM
Have you given the new List PowerApps a try?
Should be something like this:
https://powerusers.microsoft.com/t5/General-Discussion/CASCADING-DROPDOWN-WITH-3-COLUMNS/td-p/80483
Mar 26 2018 09:51 AM
I am trying to make this process work for me in Sharepoint.
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.
Mar 26 2018 09:53 AM
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.
Mar 26 2018 10:51 AM - edited Mar 26 2018 10:54 AM
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-... from @Daniel Christian