# Sports. Betting. Pool. No money involved **URL:** \ **Category:** Ask for Help\ **Created:** [February 12, 2025, 2:37am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995 "2025-02-12T02:37:28Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Noman\_Chaudhry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noman_chaudhry/32/85114_2.png) [@Noman\_Chaudhry](https://community.glideapps.com/u/Noman_Chaudhry)\ **Post date:** [February 12, 2025, 2:37am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/1 "2025-02-12T02:37:28Z")
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 ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 12, 2025, 2:42am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/2 "2025-02-12T02:42:08Z")
What have you done so far? ---
**Author:** ![Noman\_Chaudhry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noman_chaudhry/32/85114_2.png) [@Noman\_Chaudhry](https://community.glideapps.com/u/Noman_Chaudhry)\ **Post date:** [February 12, 2025, 3:17am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/3 "2025-02-12T03:17:41Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 13, 2025, 12:48am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/4 "2025-02-13T00:48:23Z")
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. ---
**Author:** ![Noman\_Chaudhry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noman_chaudhry/32/85114_2.png) [@Noman\_Chaudhry](https://community.glideapps.com/u/Noman_Chaudhry)\ **Post date:** [February 13, 2025, 3:04am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/5 "2025-02-13T03:04:13Z")
Thank you. Am I creating a separate tab for each table then ? ---
**Author:** ![Yurmuthyr](https://avatars.discourse-cdn.com/v4/letter/y/ad7895/32.png) [@Yurmuthyr](https://community.glideapps.com/u/Yurmuthyr)\ **Post date:** [April 13, 2025, 2:45am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/6 "2025-04-13T02:45:34Z")
Im looking to do something very similar. Have you got it to work the way you were hoping? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 13, 2025, 10:39am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/7 "2025-04-13T10:39:34Z")
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. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [April 14, 2025, 8:30am UTC](https://community.glideapps.com/t/sports-betting-pool-no-money-involved/79995/8 "2025-04-14T08:30:33Z")
Welcome to Glide’s community forum 👋 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. > **[No-Code App Templates - Create Customizable Apps Without Coding | Glide](https://www.glideapps.com/templates)** > > Browse 100+ free, ready-made templates and business apps that you can customize to your needs quickly without code.