Student Scheduler Sheets Script

TomHinkle.net

Student Scheduler Sheets Script

A Google Sheets Container-Attached Script for scheduling special blocks
This is a complicated little tool for building custom schedules based on requests. The tool is intended to support something like a a "What-I-Need" block or "Extra Help" sessions or perhaps choice options on a Field Day.
Features:
  • Allows scheduling as many activities over as many days as you like (e.g. 4 options for field day or 20 workshops over 10 days -- whatever)
  • Allows limiting attendance at any event to a number of your choosing.
  • Allows multiple competing streams of information (e.g. pre-assigned schedules + high priority requests + lower priority requests).
  • Generates schedules automatically and provides feedback on why each person was scheduled where they were (e.g. if someone didn't get their request because of a limitation, it says so to help you troubleshoot)
  • Helps you manage the many sheets it generates to keep this more usable.
  • Allows emailing participants the schedule automatically.
  • Supports scheduled automation.

Tags

Tech used in this project:
Google Apps Script JavaScript School Spreadsheet