Learn new Google Workspace Skills
I have an admin that wants to create a GForm for teachers to give info about a student for an IEP or other semi-confidential information. They would like for teachers not to see the info from other teachers about the student...and they need there to be a narrative for some questions.
The end goal of this is to create a GDoc with all the info about one student in one place. I was thinking Doc Appender, but how do I link the student name to the doc? We can have them put the student name on the GSheet from the Form...but that is going to need to be manual entry on the Sheet right?
To solve this question I suggest two forms:
Above is the folder structure for the system. The IEP Request form creates the IEP Document named as the student name.
Below is the IEP Referrals Folder where all the IEP's are created. Doc Appender reads the files in this folder, and modifies the Student Name Multiple Choice question on the IEP Teacher Comments Form
Doc Appender reads the folder and updates the question every hour and after every form submit. If you want to test this out, create a new student with the IEP Request Form, then fill out a new teacher comment on an existing student so you can see the new student get added to the teacher comment form. The refresh this page to see the new student also appear in the IEP Referrals folder. If you add a comment open that student's file to see the appended information.