Sports. Betting. Pool. No money involved

Hi team - I was wondering if someone would give me an answer with the functionality of Glide. I’m trying to build a betting app where a group of friends will be in a pool with one admin running the pool. I’m not sure if I’m getting the desired look due to my skill level in Glide.

App Summary description:

Create a pool with 10 players.
Each player picks their team.
The leaderboard summaries the standings

Thanks,
Noman

What have you done so far?

I have a Google Sheet data imported with players and matches to be played. Is there a cookbook I can follow to:

  • pick a team
  • display the winners after each match
  • Tally the winners in a leaderboard format

The structure would be somewhat like this.

1. Players Table

This table will store information about each player in the pool.

PlayerID Name
P001 Player 1
P002 Player 2
P003 Player 3

2. Teams Table

This table will store information about each team that players can pick.

TeamID Team Name
T001 Team Alpha
T002 Team Beta
T003 Team Gamma

3. Matches Table

This table will store information about each match, including the teams playing and the outcome.

MatchID Team1ID Team2ID Match Date Outcome
M001 T001 T002 2024-01-01 T001
M002 T003 T004 2024-01-02 T003
M003 T001 T003 2024-01-02 Draw

4. Picks Table

This table will store the picks made by each player for each match.

PickID PlayerID MatchID Outcome
PK001 P001 M001 T001
PK002 P002 M001 T002
PK003 P003 M002 Draw

Then, you can do a relation & lookup from the picks table to the matches table using the matchID, get the outcome, and determine if the outcome of the pick matches the actual outcome of the match.

Give points to users based on that, and go back to Users table, make a relation to the Picks table, and rollup to get their total points.

2 Likes

Thank you. Am I creating a separate tab for each table then ?