LinkedIn
Twitter
Hello Guys,
I have been working on a small AppSheet project called "Student Record." This app is designed to help teachers in a school keep track of their student's records.
Here are the functional details of the app:
[Click on the image for an enlarged view]
1. A sign-in page will appear first if a teacher accesses the app.
2. When signed in, the Teacher's home page will appear, where they can see their profile, their students, and their colleagues.
3. By clicking on "My Profile," the teacher can view the details they provided during sign-in.
4. "My Students" contains the student details, where the teacher can add new students, and edit and delete existing entries.
5. Detailed view of a student.
6. "Colleagues" contains a list of teachers who are associated with the Teacher.
I am currently using a Google spreadsheet called "StudentRecord" to store the details of teachers and students. Whenever a teacher signs in to the app, their details are saved in the "Teacher" table, and all students' details, are in the "Student" table. I, the admin, manage this Google spreadsheet. Therefore, it is not accessible to the teachers.
StudentRecord:
1. Teacher Table
2. Student Table
3. Table to be created for Teacher "Name1"
I want to create individual Google sheets for each teacher that only include their students' records from my app. This will allow me to verify and send a monthly student report to each teacher, along with their payroll. With this data, the teacher can then create their student progress report. Can you please provide me with a solution to achieve this?
I also want to know if AppSheet will provide the sign-in feature when I deploy my App.
| User | Count |
|---|---|
| 16 | |
| 10 | |
| 10 | |
| 8 | |
| 3 |
