# Create some kind of two sided attendance tracking app?
**URL:** https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848
**Category:** Ask for Help
**Created:** [November 12, 2024, 1:58pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848 "2024-11-12T13:58:33Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@bram](https://community.glideapps.com/u/bram)
#### Post date: [November 12, 2024, 1:58pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/1 "2024-11-12T13:58:33Z")
I’m just wondering if there is a way, without using up 5k rows, to have an attendance tracking app for a football team. So the player would log in, say yes/no to attending events (trainings, matches, etc.) and the coach would have a list of players that have said yes or no.
I guess I might just want a way to create an list with the names of players that have said yes in one column in a data table where the rows are the events.
So if Player A logged in, said yes to Event 1, the coach would see that Player A is coming.
I know I could just add rows but 3 events per week x 52 x 30 players is a nightmare. Even if it works for one team, it’s not scalable.
Maybe there is a way to use user-specific columns and have a super user? that can access them and make calculations on them or something?
Any help is appreciated!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 12, 2024, 2:10pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/2 "2024-11-12T14:10:06Z")
What you could do is use one row per event, and then use a multiple files column to store an array of PlayerIDs of those who are attending.
When a Player says yes, use a Make Array column to add their ID to the existing array.
If a player changes their mind, use a Remove Element from Array column to remove them.
To get a list of players attending any event, create a multiple relation in the Events table that matches the Player array with the PlayerID column in the Users table, then use that in a Collection.
> [@bram](#):
>
> Maybe there is a way to use user-specific columns and have a super user? that can access them and make calculations on them or something?
No. User specific columns are exactly what they say - User specific. Meaning no other user can ever see any other users data. No matter how “super” they are 😉
---
### Author:  [@bram](https://community.glideapps.com/u/bram)
#### Post date: [November 13, 2024, 4:45pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/3 "2024-11-13T16:45:53Z")
Thanks Darren! Will try this out now and update on how it goes 🙂
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 13, 2024, 5:00pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/4 "2024-11-13T17:00:47Z")
I have a template in the template store called daily attendance that seeks to mitigate row consumption as much as possible.
> **[Daily Attendance | No Code App | Glide](https://www.glideapps.com/templates/daily-attendance-gg)**
>
> Build your app with this ready-made Daily Attendance today. Modify its appearance, add your data and launch your app. No code needed.
---
### Author:  [@bram](https://community.glideapps.com/u/bram)
#### Post date: [November 13, 2024, 5:30pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/5 "2024-11-13T17:30:53Z")
Hi Darren, sorry but I am a bit unclear.
I’m at the beginning with no players attending any events. I have the events organized with one row per event on a table, I have a list of all players on a separate table.
What would I be using the multiple files column at first and what action would I use to “move players around” when they say yes or no to attending?
Thanks again!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 13, 2024, 11:49pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/6 "2024-11-13T23:49:53Z")
> [@dizzy A NEW way to Trebuchet!](https://community.glideapps.com/t/a-new-way-to-trebuchet/72402):
>
> wave Hey fellow Gliders! If you haven’t heard of the Trebuchet method, it’s a term coined by @Lucas_Pires that refers to creating inline arrays. Inline arrays can be an efficient way to create relations without requiring a helper table thereby preserving your row count! Previously, the Trebuchet method required about 6 columns and 2 custom actions (4 updates to add and remove a single item). This new version of the Trebuchet method cuts that usage IN HALF star_struck (3 columns, 1 action). …
It’s baked in this video by @Robert_Petitto .
---
### Author:  [@bram](https://community.glideapps.com/u/bram)
#### Post date: [November 14, 2024, 1:37am UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/7 "2024-11-14T01:37:12Z")
This seems great! The problem I am having is that this only works if you want to store the events within the user’s profile, not the other way around, so it isn’t clear to me that you can see the players attending at the events page so much as you can see the events a specific player is attending at his page.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 15, 2024, 1:36am UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/8 "2024-11-15T01:36:17Z")
I’m not sure I understand what you mean. You’re storing a list of player IDs in events table right?
> [@Darren\_Murphy](#):
>
> To get a list of players attending any event, create a multiple relation in the Events table that matches the Player array with the PlayerID column in the Users table, then use that in a Collection.
You do this to see the list of players attending an event.
In reverse, go to the Players table, and do a multiple relation to the Events table’s array to see all events a player is attending.
---
### Author:  [@bram](https://community.glideapps.com/u/bram)
#### Post date: [November 28, 2024, 10:16am UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/9 "2024-11-28T10:16:15Z")
I am storing a list of events in the user’s profile. Using the Trebuchet method doesn’t make it possible for me to store the players on an event, as it is impossible to complete the step at around 14:50 on the video, since you can pull data from the user profile to another table but not from another table to the user profile/table.
Am I understanding it incorrectly? Any help appreciated despite the late response 😅
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 28, 2024, 2:33pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/10 "2024-11-28T14:33:43Z")
Can you show us how you’re setting it up?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 29, 2024, 1:54pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/11 "2024-11-29T13:54:10Z")
It all depends on how you’re setting up the data. Here’s a setup that worked for me:
https://www.loom.com/embed/f7d2fd43eff6442f873304382d5c65af
---
### Author:  [@bram](https://community.glideapps.com/u/bram)
#### Post date: [November 29, 2024, 3:00pm UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/12 "2024-11-29T15:00:03Z")
I’ve set it up somewhat simply where in the users table I have users with different roles (coach, player) and a calendar table with all events. Ideally I would have the players sign in and be able to say yes/no to events and appear as an array on the calendar table under the specific event/match, so then the coach can see who’s attending and who isn’t for each event.
I’m not somewhere I can speak and record atm so will attach the video later.
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 30, 2024, 1:50am UTC](https://community.glideapps.com/t/create-some-kind-of-two-sided-attendance-tracking-app/77848/13 "2024-11-30T01:50:03Z")
- Have 2 multiple files column which you would use as two arrays to store the players who are attending and not attending.
- Have two Make Array columns, adding the “Attending Array” and the “Not Attending Array” with the signed-in user’s ID/email.
- When the user presses the Attend/Not Attend buttons, set the right Make Array column above to the Attending Array/Not Attending Array.