This project sends emails telling students that they were marked absent for a class. This project is kept in the PST timezone, so being in a different timezone may cause the dates in the software to change a little earlier or later than your local timezone.
- Google Sheet to copy
- Google Form for Reference
- How to set up the software
- How to "deploy" the software
- How to use the software
The web application will become very slow if too many past attendance data is logged (check out the sheet called "Past Attendance"). Please regularly clear this sheet out by deleting earlier rows (but not the top-most row).
This program runs on Google's App Script, which uses Javascript and HTML. To run the software, the user deploys the web application. When the webpage is being loaded, data stored in the spreadsheet is cleaned and returned to the webpage for display. After the user hits the Submit button on the webpage, the data on the webpage is sent to the server side for emails to be sent and data appended to the spreadsheet. The server side returns the new information to display the client side, which is the web app.
All contributions are welcome. Before any actions are taken, however, please let me know what changes you wish to make by filling an Issue. When you make a contribution, please make a pull request, and I will look at your changes.
- Right now, there is a save button, but there is no load feature to automatically check the people who were absent according to the saved data. There is a way to do this by hashing everyone who was absent according to the saved data, and then checking each person in the table to see if they are in that hash (and was therefore absent). Unfortunately, I am unable to make hashing work by trying to hash the 3 parameters of {Name, Period, Class Name} without turning it into an object. Hashing with objects doesn't work, since their addresses are being compared instead of their contents. Any work on this is greatly appreciated.
This project was developed by William Tang as a gift for his AP Physics 1/AP Chemistry teacher to massively reduce time spent emailing students that they were marked absent. Anyone is free to use this software.