I am building a coaching platform on Glide Pages. Each coach has multiple “groups” with up to 12 users in each group. I am trying to make it to where a coach can select which courses their groups are able to see, and then choose the order the courses will show up on the list of courses when their users signs in.
I was using the Trebuchet method with a column in the courses table called “Groups Assigned”. This was allowing me to filter the courses list by the groups assigned column and the group name in the user profile.
I cannot come up with any possible way to have the courses list be sorted in the order the coach specifies.
Data tables I have: Users Table, Groups Table, Courses Table
Any tips or recommendations would be greatly appreciated.