How to Dynamically Filter a Dropdown Based on Another Field in a Baserow Form?

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

I’m building a form in Baserow where users need to report issues in a specific unit of a building. The form has the following fields:

Issue (Text input)
Select Building (Dropdown – fetched from a table listing all buildings)
Select Unit (Dropdown – should dynamically show only units from the selected building)
Right now, both Select Building and Select Unit have separate queries to fetch their lists. However, I need Select Unit to update dynamically based on the selected building so that only relevant units appear in the dropdown.

What I Need Help With:
How can I set up Select Unit so that it filters only units belonging to the selected building in real time?
Is there a way to do this using linked tables, filters, or a specific formula?
Any guidance on achieving this in Baserow would be greatly appreciated.

Thanks!

2

Hi @seanclt, I believe this is the feature you’re asking about: Cascading dropdown options - #16 by olgatrykush

@frederikdc do you think there are currently any possible workarounds for cascading dropdown options?

3

You can work with conditions in the form to determine which field needs to be shown, but this is only managable for a limited number of items.

  • You have a linked field to the Buildings (type) table
  • You have a single select field for each possible building type or for each possible combination of units
  • You set a condition in the form view that shows the corresponding field based on the selected building
  • You have a formula field in the table that checks which single select field has a value to determine the selected unit