I have a table that shows a list of classes. In another table, a list of students with a class column. Through a simple relation, the tables are linked so that each class has it’s own students. Glide 101, no drama, works perfectly.
Now what if a user wants to add extra classes and assign the existing students to some of these? So one student might be in 3 different classes, another student in 5 different classes (their regular class, and some special classes).
I have gone with a manual approach - make a Boolean column for each new class and check students in that class. Then I created a list of the special classes to give me an inline list, and then attach an inline list of the students filtered by the Boolean column for that class. It works, but it’s not dynamic and each one has to be done individually (there are 13 special classes!).
I’m using this approach until I figure out a more efficient method.
Another option is to use use an If then Else to convert the Boolean to the class name, and then create a relation, but again, this would involve having a separate relation for each special class.
I’m confident there’s a better way, I just can’t figure it out.