sean.fiene@nintex.com

Three-Tier Cascading Drop Downs: Do Go Chasing Waterfalls!

Blog Post created by sean.fiene@nintex.com Support on May 20, 2015

Nintex Forms allows for Cascading Drop Downs which can improve the functionality of your forms, but what if you wanted to include a third-tier to the cascading drop down?

 

Let's take a look at how to configure a three-tier cascading drop down using Nintex Forms!

 

The Setup

 

For this example, we are creating, in total, four lists (List A, List B, List C, and Meal Order).

 

Below is what List A -  C look like:

 

List
Configuration
ListA.pngListAsettings.png
ListB.png

ListBsettingsLU.png

ListBsettingsSL.png

ListC.png

ListCsettingsLU.png

ListCsettingsSL.png

 

Notice the following:

 

  • List A contains the Single Line column 'Title' data that will feed into the 'Meal Time' List Lookup used on List B.
  • List B contains the List Lookup column, 'Meal Time' (from List A), and a Single Line column, 'Meal Type'.
  • List C contains the List Lookup column, 'Meal Type' (from List B), and a Single Line column, 'Beverage'.

 

These are the columns used when creating the list, 'Meal Order', which will be where we build our Nintex Form.

 

Below is the configuration of the 'Meal Order' list columns:

 

Meal Order - Column Settings
MealOrder-MealTime.png
MealOrder-MealType.png
MealOrder-Beverage.png

 

Notice the following:

 

  • The 'Meal Time' List Lookup references the 'Title' Single Line Text column of List A.
  • The Meal Type List Lookup references the 'Meal Type' Single Line Text column of List B.
  • The 'Beverage' List Lookup references the 'Beverage' Single Line Text column of List C.

 

Now, let's take a look at how the List Lookup Controls are configured on the Nintex Form for Filtering:

 

FormDT.png

 

The 'Meal Time' control will not have any filtering applied, so we can move on to 'Meal Type'.

 

MealTypeLLUConfig.png

 

'Meal Type' is going to be filtered by the output of the control, 'MealTime' when the value of 'Meal Time' matches that of 'Meal Type'.

 

Now, let's move onto 'Beverage'.

 

BeverageLLUConfig.png

 

'Beverage' will be filtered by the output of the control, 'MealType' when the value of Meal Type matches that of 'Meal Type'.

 

...the Magic.

 

PotRoastImage.png

ChickenImage.png

Outcomes