Hello AppSheet Community,
I have a particularly cumbersome spreadsheet that teachers at my school use to request students from other teachers and check them in and out by date and time. Our teachers would be better served by an app that could do the same. I have tried to make an AppSheet app that fills this need but I'm just not able to accurately describe/visualize my app well enough to create the app I need. I wonder if there is anyone out there who could take a look at my spreadsheet and give me pointers about how to turn it into an app.
Here is a link to my spreadsheet: https://docs.google.com/spreadsheets/d/1Flucz4afXBhjT7kfMOL93dSJQZnFgjdFza899DTDlRo/edit?usp=sharing
The first four tabs along the bottom are nothing to worry about but the tabs starting with "Bailey" represent each teacher at the school. Each teacher has a roster of students that any other teacher can request by selecting their name in the correct day. The requested student can then by tracked using the Check Out and Check In boxes under each day.
I know I need a sheet named "Students" and another one for "Teachers". Teachers should have a "Name" property and an "Image" property. Students should only have a "Name" property. A user should be able to view a roster of each teacher's students and request them. The student's homeroom teacher must be able to check the student out of their class and the requesting teacher must be able to check the same student in to their class.
I'm not looking for anyone to create the app for me, just a little help getting it organized, so if anyone can help with that, I'd appreciate it.
If this is the wrong place to post this, please forgive my ignorance.
LinkedIn
Twitter
