cascading option in sharepoint list

Question

is it possible to get cascading feature for 2016 SharePoint list?
if yes how it is possible?

Answer 1

You could use lookup column and custom codes to achieve this. You could refer to this article Cascading of Lookup Dropdown Fields on SharePoint 2013 and Office 365

Follow these steps:

1.Create a SharePoint List named Company.

2.Create a SharePoint List named Employee, then create a Lookup column named as Company from the Company List

3.Create a third List as Database, then create two Lookup columns. The first column is Company from the Company List, the second is Employee from the Employee List.

4.Go to the Database List >> click Default New Form in the List tab

5.Click Add a Web Part >> add Script Editor in the “Media and Content” folder

6.Click EDIT SNIPPET >> enter the following script command (19088-script.txt)>> click Insert button >> click Stop Editing in the PAGE tab

7.In the Database List, when you adding a new item, if you select the Company value, then the Employee value will auto binding.

---

If the response is helpful, please click "Accept Answer" and upvote it.
@sns

Answer 2

Hi Echo Du,

Thank you for the support.
I tried all the above steps as it is. I faced below error at the end. I am not sure, may be do I need to change the code you have shared, Please suggest what to do?

Answer 3

You don’t need to change the code. In your list, the “company” field name is lowercase, just change it to uppercase “Company”. Check if it works for you.

----------

@sns
You can directly click “Comment” option under ”My Answered“ to put forward your opinions and thoughts about solution that I propose.

If the response is helpful, please click "Accept Answer" and upvote it.

Answer 4

Hi Echo Du,

Thank you . It worked