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?
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.
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
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?
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.
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
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!
