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:
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.