Hello,
I’m new on Glide and am struggling to achieve something that seems simple enough.
The use case
During a pre-enrollement day for a school, would-be students are evaluated on different criteria during different activities by coaches.
The data
There are 4 tables:
- Students: name, email, coach name, coach email
- Activities: name
- Criteria: name
- Evaluations: evaluation, student foreign key, activity foreign key, criteria foreign key
A student attends multiple activities
An activity has many students
An student has multiple evaluations (if there are 2 activities and 3 criteria, he will have 6 evaluations)
My UX
I planned on something very simple like this
What I’ve tried
I have a table with my students, a table for my activities, a table with attendance (=link between student and activity) and a table with my evaluations with criteria, evaluation and attendance foreign key.
I have managed to make the first screen work. For the second one, I can show all students attending the activity.
What I’m struggling with
How can I filter the evaluations table to only show those related to a specific student/activity couple ?
I would have loved to use a simple evaluation.activity_ID = selected_activity && evaluation.student_ID = selected_student but I can’t make sense of the context variables in the filters.
I’ve tried so many things on the app that it’s turned into something I can’t really show. If my explanation is not clear enough, I can tidy the app and share it here
Thank you !