One of us lives in an LLC, or Living Learning Community, with 80 or so other students. We realized it would be useful if we knew which of those students were taking the same classes as us so we could form study groups or have contacts if we miss class, so we made this hack.
What it does
Our project consists of a Google Form and a Google Spreadsheet, and when a student submits their name and the classes they are taking in the form, their responses show up in the spreadsheet sorted by class. This means that after all students have submitted their form, the spreadsheet shows which students are in which classes. Students can find their classes in the spreadsheet and see who else is in those classes.
How we built it
We used a Google Apps Script that gets triggered by form submissions.