This is something I can’t get my head around for some reason!
I’m managing a few soccer leagues, getting people registered then getting paid back for them, coordinating shirt purchases, etc. I’ve been looking for a simple way to manage this as a gateway to understanding Coda a little better for work purposes.
What I have right now is a Coda doc with a ‘leagues’ table and a ‘players’ table. Each league costs a certain amount per person, and some people are signed up for one or both leagues. To link the data, I can either have a lookup Player column in the League table, or a lookup League column in the Player table. However, I am unclear on how to build on that link in the same table. For instance, I would love a checkbox or button that indicates the Player has paid me back for the league, so that it automatically reduces that amount from what they owe. What am I missing here? How do I get tables to share the rest of the row’s data from a lookup column?
I want to solve this in kind of a smart way because I want to use this doc ongoing. I want to add leagues and players over time without having to code in amounts over and over again.
I’ve watched all the schema videos, read the lookup guide, and still can’t figure out how this works!