Question

I need to create a small game system in Notion where I can create games by day and add scores for different players.

1- A table with 10 players.
2- A table with all days.
3- A table for games.

I need to add a scores for each game by day and by player.

The idea is that I create a new game, select a date, select the players and I end up with a "score" column for each player to add a score for that game only.

If I create a second game, I select the date and another "score" column will be available so I can add the score for each player in that second game and date.

And so on for all the games I create.

Actions: New game, select date, select players and add scores for everyone. After all days I will have a formula to have the best scores.

I already have the complete list of players (10) and the complete list of days (15).

How should I create the games table so everything work?

I related days and players to the games table so I can select a date and the persons in each new game. But how to have the score column for each people in each one of the games and different days?

Any ideas?

Thanks.

Answer 1

The score belongs to the players... I would not try and overcomplicate this rather I would remove table the days table and use select property type where the Days are options because you will have many players playing one game and many games? being played by one player.

This can be in the players database assuming the game is running all 15 days.
You can do a roll up property to get the total game score in the all days database. The total score would be per day.

To find the top score by player you will have to use a filtered view of the data of the players to get their game score. I created a template to help you get started there will be alot of duplication of processes (pages) to get what you are looking for. Scores for different events, dates and users in Notion