How to Set Up Three-Level Geographic Cascading: Region → Country → City
What This Does
Geographic data entry requires three dependent dropdowns. Monday.com can't enforce these dependencies, leading to invalid location combinations.
Zorpa supports multi-level cascading (3+ levels). Region selection filters Countries, Country selection filters Cities.
Complexity: advanced | Feature: Cascading Dropdown
Prerequisites
- A Monday.com account (any plan)
- At least one board with dropdown columns
- Zorpa installed from the Monday Marketplace
Step-by-Step Setup
Step 1: Install Zorpa
Navigate to the Monday.com Marketplace, search for "Zorpa", and click Install. Add it to the board where you want dropdown automation.
Step 2: Create three dropdown columns: Region, Country, City
Once installed, open your board and switch to the Zorpa Board View. You'll see the Rules tab where all your automations are configured.
Step 3: Open Cascading tab
Click "Add Rule" and select the dropdown column that should trigger the automation.
Step 4: Set Level 1: Region → Country mappings
Follow the on-screen prompts to complete this configuration step.
Step 5: Set Level 2: Country → City mappings
Follow the on-screen prompts to complete this configuration step.
Step 6: Save and enable
Follow the on-screen prompts to complete this configuration step.
Real-World Examples
Real Estate Commercial
Dropdown: Region → Market → Submarket (Northeast → NYC, Boston, Philly → Manhattan, Brooklyn, Midtown) Trigger: When value changes to "Northeast" Action: Show only Northeast markets, then filter submarkets per market Impact: Invalid market data = wrong comps and pricing
A CRE firm tracking properties across 50 markets. Without 3-level cascading, brokers select 'Midtown' as a submarket of 'Chicago' — an invalid combination.
Logistics Shipping
Dropdown: Region → Hub → Route (West Coast → LAX Hub, SEA Hub → LAX-PHX, LAX-SFO) Trigger: When value changes to "West Coast" Action: Show only West Coast hubs, then filter routes per hub Impact: Wrong route assignment = late delivery
A logistics company with 3 regions, 12 hubs, and 80 routes. Dispatchers need fast, accurate route selection — not scrolling through all 80 routes.
Management Consulting
Dropdown: Practice → Industry → Sub-Vertical (Strategy → Healthcare, Tech, Finance → Hospital Systems, Payer, Biotech) Trigger: When value changes to "Strategy" Action: Show only Strategy industries, then filter sub-verticals Impact: Wrong classification affects staffing and expertise matching
A consulting firm classifying engagements needs Practice → Industry → Sub-Vertical alignment. 'Healthcare Payer' under 'Operations' makes no sense if it's a strategy engagement.
Troubleshooting
- Rule not firing? Check that the dropdown column is correctly selected and the trigger value matches exactly (case-sensitive).
- Form submissions not triggering? Ensure you're using Zorpa's form-safe trigger mode, not a standard column change trigger.
- Actions not executing? Verify that the target person/column exists and that Zorpa has the necessary board permissions.
Next Steps
Once your first rule is working, consider adding:
- Cascading dropdowns to validate data entry
- Cross-board sync to keep multiple boards aligned
- Additional trigger rules for other dropdown columns
Step-by-Step Setup
Install Zorpa
Create three dropdown columns: Region, Country, City
Open Cascading tab
Set Level 1: Region → Country mappings
Set Level 2: Country → City mappings
Save and enable
FAQ
Ready to automate your dropdowns?
Install Zorpa and set up cascading dropdowns, smart automations, and cross-board sync in minutes.
Install Zorpa -- Free