Shift scheduler
Assign people to shifts or events based on their recurring availability
Sign up
This script helps you find people who are available for a given shift or event. The inputs that it expects are laid out in the script settings screen. At a high level, you'll need three tables:
- Shifts (or Events): one record for each shift/event, with fields for start time, end time, and links to people who are assigned to the shift
- People: one record for each person on your staff
- Availability: one record for each (person, time range) pair. For example, if I'm available Mon 9AM-5PM, Tue 9AM-5PM, and Wed 9AM-12PM, I would add three records to the table. Each record can also be set to repeat weekly.
View source