Problem Statement
Create a SharePoint dropdown list to Request Asset.
Output will look like this,
Solution
We need to create four SharePoint lists as shown the table below Problem statement.
List1. RequestType
The list contains Type of requirement (Hardware/Software)
-
Create SharePoint List named “RequestType”
Add following data in title column
List 2. RequestAsset
The list contains sub type of the requirement,
Hardware - Input, Output
Software - Programming, Configuration
- Create SharePoint List named “RequestAsset”
- Go to setting and create column Named “RequestType” and column type is “Lookup” as shown below.
- All column will look like this
- Add the following data in this list
List 3. AssetNames
The list contains sub type of the requirement,
Input - Keyboard, Mouse, JoystickOutput - Monitor, PrinterProgramming - Visual Studio, Matlab, NetbeansConfiguration - Infopath, Sharepoint Designer
- Create SharePoint List named “AssetNames”
- Go to setting and create column Named “RequestAsset” and column type is “Lookup” as shown below.
- All column will look like this
- Add the following data in this list
All data is Set for cascading. Now to access this data, create fourth list
List 4. New Requirement
This is the list where we can achieve our output,
- Create SharePoint List named “New Requirement”
- Add three lookup columns as shown below
Refer below 3 screenshots for three columns,
RequestType column
RequestAsset Column
RequestNames Column
- All column will look like this
- Your list will look like following, To write code for cascading, click on New item as shown below
- Following new form will open
- Edit the form by using Gear icon on Top Right side
- Click on Insert button on Top Left side then select Media and Content, then click on Script Editor and click Add button on right
- Click on edit snippet
- Paste below code and click insert and the stop editing the page
- Following piece of code is for first level cascading dropdown
Output
If you select Hardware in first column, Request Asset will filter with Input and Output Only
If you select Software in first column, Request Asset will filter with Configuration tools and Programming Only.
Following piece of code is for Second level cascading dropdown,
Output
If you select Request Type as Hardware and Request asset as Input then
Third column will filter with “Keyboard”, ”Mouse”, Joystick” dropdown options.
If you select Request Type as Hardware and Request asset as Output then
Third column will filter with “Keyboard”, ”Mouse”, Joystick” dropdown options.
Join the conversation! Your thoughts help the community grow.