Notion Answers

Get help from other Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Scores for different events, dates and users in Notion

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.

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect