Sports. Betting. Pool. No money involved

Ask for Help
1

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

2

What have you done so far?

3

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
4

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
5

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

6

Im looking to do something very similar. Have you got it to work the way you were hoping?

7

It kind of depends on how you want the app to look, I don’t usually have tabs for all entities.

Just a further note, in most cases, I use the Users table as a base table for all tabs.

8

Welcome to Glide’s community forum :waving_hand:

Alternatively, you could have a look at Glide’s template gallery and see if you find a template there to give you a head start.