cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Three levels cascading lookup?

With the last 2.6 version of Forms (On Prem), I'm trying to do a three levels cascading dropdown :

 

States List

State : Text Dield

 

Regions List

Region :Text Field

State : Lookup Field

 

Cities List

City : Text Field

Region : Lookup Field

 

Customer List

In the form, I have three lookup list fields to choose step by step the city (states, region, city)

 

  • The first lists all states
  • The second lists regions filtered by state(no problem)
  • The third lists cities filtered by region (no result)

 

I tried some tests :

  • If I filter cities based on a text box where I enter manually the region, it's ok.
  • If I filter cities  based on the first field, it's ok.

 

(In fact, I wanted to just measure performance of the list lookup without page refresh : fetch almost 900 cities from 36.000 in 500ms. Awesome!!!)

Labels: (2)
Tags (2)
0 Kudos
Reply
5 Replies
Not applicable

Re: Three levels cascading lookup?

Hey Jean-Francois, our Tech Evanglelist Sean Fiene​ is in the process of creating a blog post on this exact scenario Will post here once it's up!

0 Kudos
Accept as Solution Reply
Not applicable

Re: Three levels cascading lookup?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Three levels cascading lookup?

This is exactly what I was doing but I had a strange problem with a lookup field.

I found the problem with CAML Query Helpder, create a new field and now everything works fine.

Regards

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Three levels cascading lookup?

Hi Jean, Looks like everything worked out. Please mark Emily's or your response correct for others to find a solution with similar needs.

Thanks!

Accept as Solution Reply
Not applicable

Re: Three levels cascading lookup?

Trying to achieve below, really appreciate the suggestions for case 2

Scenarios      

             case1    case 2   case3

  • List A:   breakfast   dinner   dinner
  • List B:   sandwich   pizza      chicken
  • List C:   water          .....            tea
for cascading downdown in form: for above case 2, the 3rd cascading drop down shows, please select a value... ( for this dropdown, you will not have any value to show as this combination doesnt have any value as seen in above case2)
  • My question is how to achieve this, in case 2 , in seen in screenshot below, 3rd cascading dropdown doesnt have any value depending on the selected values . soit  shouldnt even display the third cascading at all( as this combination doesnt have any value for the 3rd cascading dropdown to show)

case3:

Case2:

Really appreciate answers

0 Kudos
Accept as Solution Reply