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 wan…

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 …

Thanks Darren! Will try this out now and update on how it goes :slight_smile:

I have a template in the template store called daily attendance that seeks to mitigate row consumption as much as possible. [image] Daily Attendance | No Code App | Glide Build your app with this ready-made Daily Attendance today. Modify its appearance, add your data and launch your app.…

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 …

[image] dizzy A NEW way to Trebuchet! Community Resources 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 …

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…

I’m not sure I understand what you mean. You’re storing a list of player IDs in events table right? [image] 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…

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…

Can you show us how you’re setting it up?

It all depends on how you’re setting up the data. Here’s a setup that worked for me:

Create some kind of two sided attendance tracking app?

Ask for Help

ThinhDinh November 13, 2024, 11:49pm 6

It’s baked in this video by @Robert_Petitto .

Topic		Replies	Views
Multiple Key Ask for Help	6	307	December 12, 2022
A question about user specific Ask for Help	6	290	August 17, 2022
Attendance app? Ask for Help	3	691	July 9, 2020
Help tricks - Make users say "i will go" into a event Ask for Help	4	449	October 17, 2022
Relation or Array or ? Glide design question Ask for Help	8	628	October 9, 2022

Create some kind of two sided attendance tracking app?

Related topics