Skip to main content

I have a checkbox lookup list for countries and a checkbox lookup list for locations in those countries.

E.g.

Countries - (Lookup List 1)

  • Austria
  • Belgium
  • France
  • Greece

Locations - (Lookup List 2)

  • AUT Location 1
  • AUT Location 2
  • BEL Location 1
  • BEL Location 2
  • etc.....

Currently when I tick one of the countries (e.g. Austria), that country's locations will appear in Lookup List 2.

Is there a way to combine these two lookup lists into one cascading list so that when a country is selected, the locations appear in the same list like shown below?

E.g.

  • Austria
    • AUT Location 1
    • AUT Location 2
  • Belgium
    • BEL Location 1
    • BEL Location 2
  • France
    • FRA Location 1
  • etc....

Any help would be appreciated. Thanks.

Hi Sian Richardson‌,

You can use a Calculated Value inside a Repeating section, where the Calculated Value has the formula to get the Locations of the Countries.

Example: 

lookup("ListName","Country","CountryName","Location")

199886_pastedImage_1.png

Along with the Calculated Value, you can have Yes/No  field in corresondense to select the location option.


I'm looking to do this as well. Any suggestions?


Reply