Tracking Ping Pong game results and stats for players

[Jesse_Poteet]

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:

Airtable

Ping Pong Stats - Airtable

Explore the "Ping Pong Stats" base on Airtable.

Any help greatly appreciated!

[Casey_Stilton]

Unfortunately, the link is broken.
When we played table tennis with my friend, we used to put a note on a side corner of the table and kept all the points there. Just as player 1 + name, player 2 + name, and all the points under it.