Our school (not our district) has GAFE accounts, and I and another teacher do the administration of about 800 accounts. This year, I am trying to streamline some of the work and use some of my new JavaScript knowledge. To start, I wanted to create a form that teachers could fill out whenever a student needs their password reset. (Since we have middle schoolers, some of the possible ways an account password could be reset --- e.g., a text message to a phone --- aren't possible.)
First step, I wrote a form to collect information from the teacher about the student:
Next, I enabled the
Email Notification for Forms add-on, so that I'm emailed every time a teacher fills out the form. The step of changing the password I am planning to do manually based on the information in the Google Sheet. But finally, I changed the script in
this tutorial (showing how to send email based off a Google Sheet) so that when I run it, the teachers are informed of the student's new password.
I'm glad some of the steps are automated and that I understand the JavaScript well enough to make meaningful edits. However, if there is an easier way to do this, I'd love to hear about it.
