Good morning!
I've been trying for weeks to make an Appsheet app work like I want it to, but I'm struggling up against what I know I don't know. Here's the shortest summary I can give:
- I have Teachers with Students, and each Student has multiple Accommodations that require daily monitoring (as in the Teachers mark if they did or did not use that Accommodation every day)
- The Accommodations are the same every day, but they are subject to change.
- Students are taught by multiple Teachers
So far, I've tried a various combination of Task-Trackers, one very close example from the AppSheetTraining people, and trying to figure out the Many-to-Many JOIN Table thing, but none of it seems right. The best analogy I have to non-education is imagine multiple managers with multiple employees, and each employee has multiple tasks that can be checked off daily by all the managers.
ANY help is appreciated. I've been using this system with Sheets + Forms for years, and it's too cumbersome to update each student individually anymore. TYIA!
LinkedIn
Twitter
