# Community Basketball Tournament Management App **URL:** \ **Category:** Ask for Help\ **Created:** [November 22, 2023, 1:42am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010 "2023-11-22T01:42:27Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 22, 2023, 1:42am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/1 "2023-11-22T01:42:27Z")
New with glide. Doing 1st app. Re Community Basketball Tournament. The app will be used to manage the tournament. Create teams, add/removed players, coaches, schedule games, show results of games, show team standings. Please see images below. One is the table for games (home, team, visitor team, scores, venue, date and time. Please help in creating table (Team Standing) to show the WIN-LOSS record of each team. ![001-table_games](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df29295144ec9f0b44eced0202fa1859fad28dac.png) ![002-table_team_standing](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f495c74132ea356a60736561969b23296e088db.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 22, 2023, 3:10am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/2 "2023-11-22T03:10:12Z")
You probably could get away with calculating the winning team by determining who has the highest points. I think this would work: 1. Create make array column that combines the two team IDS 2. Create if then else column that outputs the winning team if they have the highest points. 3. In your teams table, create a relation that matches team name to make array column 4. Create query column that has this relation as the source and filter where winner \> is \> this row \> team 5. Create a rollup column that points to the relation (total games played) 6. Create a rollup column that points to this query. (=wins). 7. Create a math column that subtracts total - wins (=losses) ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 22, 2023, 4:16am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/3 "2023-11-22T04:16:25Z")
Thanks for the prompt response and assist Robert. I was able to determine the winning/losing team by doing the below cloumn (Games table): ![003-table_games_excerpt](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/250ecd18cc5844e3ada35110f2170dacaa9b8c4b.png) What I am having a hard time is relating the results (from Games table) into the Team Standing table. Again, thanks. ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 22, 2023, 4:18am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/4 "2023-11-22T04:18:08Z")
I will work to try your recommendations. Thank you. Been watching your videos, learning a lot although am just new with No Code. ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 22, 2023, 4:57am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/5 "2023-11-22T04:57:55Z")
I was able to do below following your recommendations: ![004-table_games_array](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/f/9f28e1d85f3f700cd0917e9ecf51513c1b2c7e32.png) I don’t know how to do Item 3. Thanks ---
**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:** [November 23, 2023, 12:00am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/6 "2023-11-23T00:00:03Z")
> [@Jericho\_Samonte](#): > > What I am having a hard time is relating the results (from Games table) into the Team Standing table. Wouldn’t you just need to do the query & rollup in your existing teams table opposed to having a separate Team Standing table? ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 23, 2023, 10:09pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/7 "2023-11-23T22:09:22Z")
Hi, thanks for the ressonse. I will have a separate Team Standing table. ---
**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:** [November 23, 2023, 11:03pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/8 "2023-11-23T23:03:56Z")
> [@Jericho\_Samonte](#): > > I will have a separate Team Standing table. Can you explain why you need this though? Wouldn’t the Teams table already be enough? ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 23, 2023, 11:09pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/9 "2023-11-23T23:09:45Z")
I was thinking that I can only display the Team Standing (layout) if I have a Team Standing table. You’re saying I can still do that by getting the wins and losses per team (in the Games Table)? Apologies for the questions I am asking as I’m new to all of these. 🙂 Thanks. ---
**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:** [November 23, 2023, 11:13pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/10 "2023-11-23T23:13:18Z")
No worries, I was thinking if you can already determine the total number of wins and losses in the teams table for each team, you can then: - Create a math column to calculate the win percentage. - Use a collection to display all teams, sorted by win percentage descendingly. ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 23, 2023, 11:26pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/11 "2023-11-23T23:26:49Z")
Thanks for the help. SOLVED! Exactly as you instructed. Please see below images: I generated the wins and losses from RESULTS (Games Table). Even separated the homes and visitors teams (for future use). ![006-table_games_results](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9b3e71c3c584fb9a58db5d3deb2a5ca8fdb35b8.png) Then relate and rollup the games of each team from Games Table (in Team Table). ![005-table_teams_wins_losses](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/41d0768c21b515538f6eaa17fd6c72bffc90b4dd.png) Afterwards, created Team Standing Tab (layout) then sort descending. ![007-layout_standings](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dcc5b251cad398caf49d9c77af26dfa5a3b94eed.png) Again, thanks. ---
**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:** [November 23, 2023, 11:35pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/12 "2023-11-23T23:35:24Z")
My pleasure to help. Boston Celtics fan here. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [November 24, 2023, 12:03am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/13 "2023-11-24T00:03:03Z")
Go Heat! 🏀 ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [November 24, 2023, 1:56am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/14 "2023-11-24T01:56:12Z")
Another scenario: In the Standing, GSW is Rank 1st and Team 1 is Rank 2nd. What if in their game (GSW vs. Team 1), Team 1 won over GSW? Then Team 1 shall be rank 1st instead of 2nd. Is there a way to do “tiebreakers” based on multiple criteria? (i.e. “win over the other”, “point differential among tied teams”) Thanks in advance. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 24, 2023, 2:22am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/15 "2023-11-24T02:22:55Z")
> [@Jericho\_Samonte](#): > > Is there a way to do “tiebreakers” based on multiple criteria? (i.e. “win over the other”, “point differential among tied teams”) Use a math column that combines both and then sort by that. So it might be something like “Wins \* 100 + Points Differential” ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [December 4, 2023, 12:41am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/16 "2023-12-04T00:41:45Z")
Once done with the games, the TEAM STANDING will automatically update (1st image). It will list the teams with their Wins and Losses. When you clicked the name of the team, you will go to the next image (listing all the games played). Question: Is it possible to show only the games wherein the particular team (i.e. GS Warriors) played? The games of the other teams (they are not involved with) are not connected to GS Warriors in this example (G1 and G3). Thanks. ![008-layout_standings](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cddda2f89424a7bc1ce0a196d10709f4461fd409.png) ![009-layout_played_games](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44f28fcbd89b2f3f5614d5e7a09b91a9036f282c.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 4, 2023, 3:00am UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/17 "2023-12-04T03:00:38Z")
> [@Jericho\_Samonte](#): > > Question: Is it possible to show only the games wherein the particular team (i.e. GS Warriors) played? The games of the other teams (they are not involved with) are not connected to GS Warriors in this example (G1 and G3). You should be able to use a filter on the Collection. Something like: “Team A is GSW OR Team B is GSW” ---
**Author:** ![Jericho\_Samonte](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jericho_samonte/32/66759_2.png) [@Jericho\_Samonte](https://community.glideapps.com/u/Jericho_Samonte)\ **Post date:** [December 4, 2023, 8:43pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/18 "2023-12-04T20:43:43Z")
I did exactly as what you said. SOLVED. Thanks a lot. Appreciated very much the help. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 11, 2023, 8:44pm UTC](https://community.glideapps.com/t/community-basketball-tournament-management-app/68010/19 "2023-12-11T20:44:01Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.