Event planning Template - with added Schedule Conflict Script Block

Explore

This base extends Airtable's "Event planning" template with a Script Block that can be adapted to any similarly structured base where the requirement to detect overlapping start and end times is pressing.

​

When scheduling large Programs with many individual events at different locations, and across multiple days, it can be difficult to keep tabs on whether or not people have been double booked, and scheduling conflicts can cause chaos.

​

This script is designed to help with that problem. It will check all events in the "Schedule" table for instances where an individual Speaker from the "Speaker & attendees" table has been scheduled to be in two places at the same time!

​

For each speaker that has conflicting events scheduled, a table will be displayed under their name with a list of any offending events, so that they can be found and rescheduled.

​

Any table, view, and field names that can vary from one base to another are stored in a constant at the beginning of the script -- change the names stored in those constant values to adjust to your specific base.

​

For more detailed information, visit here.

Explore
Updated February 28, 2020 at 6:09 AM
Copied 765 times

Jeremy Oglesby

Just a regular guy.
Explore the base
Full schedule
Calendar
Friday schedule (11/15)
Saturday schedule (11/16)
All spaces
Spaces per building
Location gallery
All topics & themes
All people
Grouped by company
Speakers
Attendees
All event staff
All sponsor companies
Budget