I have a table of data for a school schedule that has columns for teachers, courses and students enrolled in those courses. (Therefore, the number of rows I have in total is the number of course-students.)
I would like to create one view where a user can see a list of teachers and drill into the list of courses they teach and then tap a course to see the roster of students enrolled. The way I have the data though, when I first tap a teacher I see each course listed 30+ times in the table since thereโs an entry of that course and teacher for each student in that course. How can I only show a discrete list of courses when I tap on the teacher and then the roster when I tap on a course?
Thank you!
Hey! Welcome to AppSheets.
Generally each View maps to either a row or a table, and since you donโt have a single row that represents a course or a teacher, itโll be hard to show a view representation of either.
Instead, if you have the ability to change the structure of your tables, is to have one table/sheet of:
See References Between Tables | AppSheet Help Center on how to generate references or connections between those tables.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |