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 ?