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