Ok we’re having some family fun playing ping pong and we want to track games. Ideally, we would be able to track game results, player stats such as wins/losses, points per game average, total points, etc. While also keeping track of game stats like who played who, what the final score was, the game date, etc.

I can’t seem to figure out how to track the game info and also have a table to that calculates player stats. The issue is having player 1 and player 2, so when I connect the Players table to the Games table, I have to connect it twice because there are two players.

Anyway, here’s the base:

Ping Pong Stats - Airtable

Explore the "Ping Pong Stats" base on Airtable.

Any help greatly appreciated!