Lookup is now relation!
We’re making major improvements to one of Coda’s most powerful capabilities: how you connect your data. Most importantly, you’ll notice the following changes:
- The lookup column type and canvas control will now be called relation to better reflect relationships created between data.
- A new column type named linked relation will represent the data on the other side of this linked relationship, replacing what is currently known as a reverse lookup. This type of column could previously only be setup via formula. Now, you’ll be given the option to generate a linked relation column on the secondary table whenever you create a relation. Within the column settings, you can toggle two-way editing of the linked relationship on or off.
How can I use relations and linked relations?
Quickly link your OKR statuses to your initiatives table and connect your team roster to the tasks everyone is assigned. Edit your selected launch dates and task statuses from either one of the tables they’re linked on. That’s just the beginning — we can’t wait to see how you use these new relational data capabilities to let your teams to get even more done with Coda.
Relations and linked relations are now available in all your new and existing Coda docs. Note that creating a new linked relation will mean that two-way editing is toggled on by default, but your existing reverse lookup formulas that will be converted to linked relations will not be two-way editable by default. You can toggle this on or off in the column options anytime.
Try creating a linked relation in your doc today and let us know what you think below!