# Event + Players + Scores

**URL:** <https://community.glideapps.com/t/event-players-scores/5145>\
**Category:** Ask for Help\
**Created:** [March 4, 2020, 12:57pm UTC](https://community.glideapps.com/t/event-players-scores/5145 "2020-03-04T12:57:59Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 12:57pm UTC](https://community.glideapps.com/t/event-players-scores/5145/1 "2020-03-04T12:57:59Z")

</div>

In the EVENTS tab I want to list all events, then once the event has finished my desire is the show the PLAYERS and their SCORE in a list (underneath).

The issue I am running into is showing the players/scores for only that event. It can be filtered, but is there a way to show only the players of that event without filtering?? (the extra step of filtering results may be beyond many of my user’s capabilities)

---

<div class="post-metadata">

**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:** [March 4, 2020, 1:48pm UTC](https://community.glideapps.com/t/event-players-scores/5145/2 "2020-03-04T13:48:24Z")

</div>

Do you ever want to show the results of more than one event, or only the current event?

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 2:12pm UTC](https://community.glideapps.com/t/event-players-scores/5145/3 "2020-03-04T14:12:21Z")

</div>

There would be multiple events, therefore, each event should reflect only the scores of its participants.

---

<div class="post-metadata">

**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:** [March 4, 2020, 2:35pm UTC](https://community.glideapps.com/t/event-players-scores/5145/4 "2020-03-04T14:35:26Z")

</div>

Would the participants ever be in more than one event?

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 2:45pm UTC](https://community.glideapps.com/t/event-players-scores/5145/5 "2020-03-04T14:45:09Z")

</div>

Yes

---

<div class="post-metadata">

**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:** [March 4, 2020, 2:52pm UTC](https://community.glideapps.com/t/event-players-scores/5145/6 "2020-03-04T14:52:31Z")

</div>

Is each event in its own sheet within Google Sheets with players/scores in rows?

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 3:03pm UTC](https://community.glideapps.com/t/event-players-scores/5145/7 "2020-03-04T15:03:17Z")

</div>

As I am new to Glideapps, I am learning. I think I am now on my 3rd try on formulating the best tab set up to use. My set tab set up:  
PLAYERS = Player Name + Email + Cell  
EVENTS = Event Name + Date/Time + Location  
SCORES = Player Name + Event Name + Score

Player Name & Event Name are related fields.

Therefore, no, I do not have each event as a separate tab. That scenario has not come to mind as I am allowing events to be added, I would not be able to do that with a new tab, could I?

---

<div class="post-metadata">

**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:** [March 4, 2020, 3:22pm UTC](https://community.glideapps.com/t/event-players-scores/5145/8 "2020-03-04T15:22:25Z")

</div>

Okay…I’m thinking this might work:

Hide the Scores Tab.  
Create a multiple relation between the Events and Scores tabs using Event Name  
On the Events page (which I assume is an inline list), select an event and in the event details layout, include an inline list of the relation you just created.

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 3:33pm UTC](https://community.glideapps.com/t/event-players-scores/5145/9 "2020-03-04T15:33:00Z")

</div>

I may have visited that option before. I get an inline list of “3 items” which includes results from different events. To try and get past this, I created a simple glideapp for testing … [v5uti.glideapp.io](http://v5uti.glideapp.io)

---

<div class="post-metadata">

**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:** [March 4, 2020, 3:58pm UTC](https://community.glideapps.com/t/event-players-scores/5145/10 "2020-03-04T15:58:25Z")

</div>

Ah…dont do a “List relation” component. Use an “inline list” component

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 4:14pm UTC](https://community.glideapps.com/t/event-players-scores/5145/11 "2020-03-04T16:14:00Z")

</div>

Am still receiving other event scores in list other than the selected event.

Are there variables in the filter feature I may be missing so the records returned match the selected event? Personally, I prefer not to use a filter, thus, the reason behind this thread.

---

<div class="post-metadata">

**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:** [March 4, 2020, 5:42pm UTC](https://community.glideapps.com/t/event-players-scores/5145/12 "2020-03-04T17:42:49Z")

</div>

Did you do the relation column first? If so, make sure your inline list is referencing the relation, not the scores sheet.

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 7:46pm UTC](https://community.glideapps.com/t/event-players-scores/5145/13 "2020-03-04T19:46:40Z")

</div>

I thought, pretty sure, I did! Still showing all. I’ve bounced it around so many times I’m bug-eyed. I can’t make it happen. Think I may need to put it away for a sec, and refresh.

---

<div class="post-metadata">

**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:** [March 4, 2020, 8:08pm UTC](https://community.glideapps.com/t/event-players-scores/5145/14 "2020-03-04T20:08:51Z")

</div>

Can you take a few screenshots of the inline list component ?

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 8:40pm UTC](https://community.glideapps.com/t/event-players-scores/5145/15 "2020-03-04T20:40:39Z")

</div>

Finally, I think I got it. Check the Events icon, click on the event and it shows the scores for that event only.

Whew! A small step, but this allows progress for future steps! Thank for your assistance and patience.

---

<div class="post-metadata">

**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:** [March 4, 2020, 8:57pm UTC](https://community.glideapps.com/t/event-players-scores/5145/16 "2020-03-04T20:57:00Z")

</div>

Nice. I’d love to see your finished app. Here’s the one I’m using for gamification:  
[itemstore.glideapp.io](http://itemstore.glideapp.io)

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [March 4, 2020, 10:16pm UTC](https://community.glideapps.com/t/event-players-scores/5145/17 "2020-03-04T22:16:44Z")

</div>

Very nice! Light years ahead of my abilities. Once I’m not too embarrassed to share my final project, I’ll forward a link.

---

<div class="post-metadata">

**Author:** ![Steve\_Kos](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steve_kos/32/16382_2.png) [@Steve\_Kos](https://community.glideapps.com/u/Steve_Kos)\
**Post date:** [November 12, 2020, 2:09am UTC](https://community.glideapps.com/t/event-players-scores/5145/18 "2020-11-12T02:09:23Z")

</div>

I’d like to create a golf scoring app.  
18 holes 4 players  
Input score for each hole  
Input additional scoring  
summarize each hole score  
keep running total

I believe each column in my spreadsheet is a hole.  
I want to input and then move to the next hole.  
Repeat till end

---

<div class="post-metadata">

**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 12, 2020, 2:43am UTC](https://community.glideapps.com/t/event-players-scores/5145/19 "2020-11-12T02:43:15Z")

</div>

I believe the right structure for your scoring sheet should be.

**Hole** | **Player** | **Score** | **Additional Scoring**

---

<div class="post-metadata">

**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 12, 2020, 4:15am UTC](https://community.glideapps.com/t/event-players-scores/5145/20 "2020-11-12T04:15:06Z")

</div>

> [@Steve\_Kos](#):
>
> Input additional scoring

What would this be used for?
