Dynamic select list

1

Hello Coda community. I’d like to create a select list column that provides options dynamically based on a different look up column. I have many deliverables per project and many projects per company. I have a deliverables table where I want to identify each deliverable to its company and project. The company look up is straightforward, but then the project look up should have only the selections that exist for that particular company. Any guidance?

Thank you!

2

Hi Jeb,

If I understood your question correctly, the info on this page should help:

If you rename the “tags” below to “company”, and events to “project” you should be close. And closer if you disallow multiple selections on the tags/company column.

image.png
image.png719×691 46.6 KB

(This screenshot is from the Plan Steps table on the Plan Steps page.)

Regards
Piet

3

Very helpful! Thanks so much. And I love your examples doc.