Wanted to share something fun instead of client work for once. My family plays Five Crowns pretty regularly, and I got tired of losing score notebooks, so I built a proper tracker in Airtable.
How it's structured:
- Log Scores — one row per player per game, with a column for each card value (3s through Kings). Game Total is a formula summing across all the value columns per row.
- Games — one row per game, pulling in all players via linked records, with a formula surfacing the Winner (lowest score wins in Five Crowns) and Lowest Score.
- Leaderboard — rollup/formula-driven view showing Games Played, Total Wins, Win Rate %, and Total Points per player, so bragging rights update automatically. (My data currently confirms one very smug family member is undefeated. 👑)
It's genuinely nothing fancy — no automations, no interfaces layered on top — but it was a fun small problem to solve with linked records + rollups, and I figured other card-game households might get some use out of it.
Grab your own copy here: Five Crowns Score Keeper
Happy to answer questions on the formulas/structure if anyone wants to adapt it for a different game!
