Cascading drop downs and Nintex Forms for SharePoint

Here we demonstrate how to create a cascading dropdown using Nintex Forms.

The video is shown on Nintex Forms 2010, but the same applies to Nintex Forms 2013.

In this written example, I demonstrate with a common State to Store relationship. You'll need to create three SharePoint lists, two of which contain the lookup information for the cascading drop down.

Create the SharePoint Lists

Create two custom lists. These custom lists form the basis for the lookups, which the main list will look the cascading information up from.

1. Navigate to a SharePoint Team Site.
2. Click the Site Settings icon, and select Add an App. Select Custom List, and call it "State". Click Create.
3. Open the newly created SharePoint list, and click new item. In the Title field, enter "VIC", and click Save.
4. Repeat step 3 and enter “NSW”, “ACT”, “NT”, “QLD”, “WA”, “TAS”, and “SA”.

Create the Second SharePoint List - Stores

1. Click the Site Settings icon, and select Add an App. Select Custom List, and call it "Stores". Click Create.
2. Open the new list, click on the List tab and select List Settings.
3. Click Create column from the available options.
4. Fill in the following options:
   1. Type “State” as the Column name.
   2. Select Lookup (information already on this site) in Thetype of information in this column is section.
   3. Select Yes for Require that this column contains information.
   4. Select States from the Get information from drop-down.
5. Navigate to the Stores list and click on new item.
6. Type  “Melbourne” in Title.
7. Select VIC from the State drop-down and click Save.
8. Repeat steps 5-7 for the below stores:
   1. “Geelong” and VIC
   2. “Ballarat” and VIC
   3. “Sydney” and NSW
   4. “Newcastle” and NSW
   5. “Canberra” and ACT
   6. “Perth” and WA
   7. “Adelaide” and SA
   8. “Hobart” and TAS
   9. “Darwin” and NT
   10. “Brisbane” and QLD

The information that will be used for the cascading dropdown items has been created.

Customizing the SharePoint List Form using Nintex Forms

Now that we have created the two lists required for the cascading drop down, we need to create the Nintex Form to display this information on a SharePoint list.

1. Create a new list or open an existing one where the data will be collected using Nintex Forms, for example “Car Dealerships”.
2. Click Nintex Forms in the Ribbon.
3. Select all of the controls on the form except the Nintex Forms label, the Save, and the Cancel buttons.
4. Right-click and select Delete so that the form looks similar to the one below.
5. Add two Label controls to the form and change their title to “State” and “Store”.

1. Add a List Lookup control from the SharePoint category of the Form Controls. Place the List Lookup control next to the State label. Resize the control to reduce its default height. Double-click on the action to open the settings.
2. Type “MyFormState” as the Name of the control.
3. Select States from the Source List drop-down, and click Save.
4. Add another List Lookup control from the SharePoint category of the Form Controls. Place the List Lookup control next to the Store label. Resize the control to reduce its default height. Double-click on the action to open the settings.
5. Type “MyFormStore” as the Name of the control.
6. Select Stores from the Source List drop-down.
7. Expand the Filtering section:
   1. Select By a controls value from the Filter available selections drop-down.
   2. Type “State” in the Where field box.
   3. Select MyFormState from the Filtered by control drop-down. Click Save.

Preview the Form

1. In the Ribbon, click on Preview. Select Generate Preview, and test out the cascading dropdown.
2. When the configuration of the form is complete, Save and Publish.

Please see subsequent replies to the original post in the attachment.