Three levels cascading lookup?


Badge +3

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!!!)


2 replies

Badge +3

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

Userlevel 7
Badge +17

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!

Reply