In a detail view, I have a ‘parent’ table called EPICS and a ‘child’ table called STAGES.
Using a ‘detail view’ on the EPICS table showing the STAGES of work in an EPIC, I want the EPIC’s name automatically added to the STAGES rows as I add each stage into the STAGES table.
Currently, I type the parent EPIC manually into the STAGES table.
I’ve tried lookups and filters but I’m a bit lost, any help will be appreciated!
I’m not clear on what you want. As a starting point, see if this doc gives you an idea you might be able to use. Play with the Filter() formula in the blue column.
PS - I like the new chip design for hoverable row references! Unobtrusive, adaptive to conditional formats, hover transform, obvious to the eye… @nathan@mallika
I updated that doc to include another variation. This represents one-to-many relationships, whereas the previous example represents many-to-many relationships. Which one to use depends on your use case.
Given Coda is so great at building relational tables, understanding how to work with one-to-many and many-to-many relationships is very useful. Thanks for your time!