Conditional Fields / Conditional Dropdowns

I’m building a CRM in Baserow and have an Account Type field with values like:

  • Marina

  • HOA

  • Government

  • Commercial

  • Yacht Club

  • Vendor

Each account type has its own set of subtypes. For example:

Government

  • Police Department

  • Sheriff’s Office

  • Coast Guard

  • FWC

  • Fire Rescue

Marina

  • Public Marina

  • Private Marina

  • Municipal Marina

  • Dry Stack

  • Yacht Club

Commercial

  • Boat Dealer

  • Service Yard

  • Fuel Dock

Is there currently a way in Baserow to:

  1. Filter the options available in a dropdown based on another field’s value (dependent/cascading dropdowns)?

  2. Conditionally show or hide fields based on another field’s value?

  3. Create dynamic forms or views where fields appear based on account type?

If these features aren’t available, what is the recommended data structure for handling entity-specific fields without ending up with one huge table full of unused columns?

Hi @Highordermarine,

  1. Filter the options available in a dropdown based on another field’s value (dependent/cascading dropdowns)?
    It’s not currently possible, but we have this thread for the feature: Cascading dropdown options - #25 by Highordermarine

  2. Conditionally show or hide fields based on another field’s value?
    Yes, it’s possible in the form view: Baserow form view guide

  3. Create dynamic forms or views where fields appear based on account type?
    For views, you can create separate views for each account type and configure which fields are visible in each one. However, fields can’t dynamically appear or disappear within the same view based on the Account Type value.