Creating a bi-directional row-level relationship between two tables

[jeo]

@anon78730478, @Benjamin_Shepherd, & anyone else

Please click through to
(2021-04-01)

Feedback requested: How would you build reverse lookups in Coda?

This week is Coda’s quarterly Hackathon! We’re exploring different ways lookup columns and reverse lookups could work in Coda. To describe the scenario, a canonical example of Lookups and Reverse Lookups currently work is shown here: [image.png] Notice how the Tasks table has a lookup to the Project table. And the Project table has a “reverse lookup” to the Tasks table. A few observations of the current pattern: The reverse lookup is defined as a formula The reverse lookup column does no…