I feel like no matter how many times I do this I can’t ever quite get my head around this issue. And I think it’s key to understanding how Coda works.
It’s about cross-table referencing. I get how to reference another table via a lookup column. However, I can never quite get how to reference another column within that table, using the display column as a link in the chain. So for instance, if I have a Group table and a Person table, and I want to lookup all the names of people in a Group I can easily do that via a lookup column.
Could be a formula like this: ([People].Filter([Group].Contains(thisRow)))
However, let’s say I want to have a column in the Group table that lists all the emails of all the people in that group - and these emails are listed in the Group table. How do I do that? And is it best done via a single formula, a set of additional columns, or a whole new table?