How to Set Up Cascading Dropdowns with Connection Fields?

App Development
1

Hi everyone,

I’m building a job vacancy system and struggling to set up cascading dropdown filters on a form. I’ve searched the docs but can’t find where to configure this.

My Setup:

I have 3 tables:

  1. Vacancies_DB (main table with the form)

  2. County List - Fields: JMC (text), County (text)

  3. Schools - Fields: JMC (text), School (text), Region (text)

What I Need:

On my Vacancies form:

  • First dropdown: Shows all unique JMC values from County List

  • Second dropdown: Shows only Counties where the JMC matches the first dropdown selection

  • Same logic for Region → School

The Problem:

I’ve added connection fields from Vacancies_DB to both tables, but when I add them to the form, I see:

  • All 50+ JMC entries (with duplicates), not just the 8 unique values

  • No option to filter the second dropdown based on the first selection

What I’ve Tried:

  • Editing the connection field in the data table (no filter options visible)

  • Looking for “Connection Filters” or “Display Rules” in form field settings

  • Checking Table Rules (but those seem to be for automations, not form filtering)

Question:

Where in Tadabase do I configure cascading/dependent dropdown filters? Is this at the table level, form level, or somewhere else?

Thanks for any help!

2

This looks like a table level issue.

You need a JMC table that schools and counties link to instead of it just being text. Then you create a grid view listing all JMCs, the user clicks the one they want (details page), then on that page you should be able to insert a record connected to that JMC, whether school or county.

3

@Phaderon is this what you are looking for? Multi-Dependent Dropdowns | Guides and FAQs

1 Like