Quick summary
This tutorial shows how to create dependent dropdowns in Coda using two linked tables and a Filter() formula, so child options automatically update based on the selected parent value. By connecting a Lookup column between tables, you can build dynamic, context-aware dropdowns without any third-party tools.
Steps
- Create a new doc in Coda where you will set up your dependent dropdowns.
- Add a first table to store your parent dropdown options, such as Categories.
- Add a column to the first table for your main dropdown values, for example "Electronics", "Clothing", or "Food".
- Create a second table to hold your child options, such as specific products within each category.
- In the second table, add a Lookup column that links each child item back to its parent in the first table.
- Apply a Filter() formula in your form or view to display only the child options that match the currently selected parent value.
- Your dependent dropdown menus are now complete — selections in the parent dropdown automatically filter the available child options.
