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:
-
Filter the options available in a dropdown based on another field’s value (dependent/cascading dropdowns)?
-
Conditionally show or hide fields based on another field’s value?
-
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?