Generate individual Google Sheets from AppSheet

Baby_Dragon12 · 05-27-2023 11:00 AM

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.

Rafael_ANEIC-PY

Hello there @Baby_Dragon12

@Baby_Dragon12 wrote:

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.

You don't need to have the data separated in different sheets for each teacher in order to create reports related to each user, if you save the email of the user when he adds any kind of data in a separate column using an initial value of USEREMAIL() and a current user system you can generate any kind of reports that you want using a google docs template, you should also check out slices as a way to limit each user to their own data.

Also, you can't do that within AppSheet, but you can solve the problem using the tools I linked above.

@Baby_Dragon12 wrote:

I also want to know if AppSheet will provide the sign-in feature when I deploy my App.

Yes, but you will have to pay a license for each user that signs into your app.