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 sheet 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.
StudentRecord:
1. Teacher Table
2. Student Table
3. Table to be created for Teacher "Name1"
However, I would like to create separate Google sheets for each teacher containing only his students' records from my App. So that each Teacher can easily access their students' records. 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.
