Use Case: You have a table of stylists, therapists, technicians, etc. (“agents”) who perform any number of services, and customers are supposed to schedule an appointment with an agent to perform a service but only when that agent is available. While you think the No-Conflict Asset Reservations script is great, it doesn’t take into account your need to schedule an agent for more than one appointment per day.
Solution: No-Conflict Appointment
script by Kamille. An improvement upon my previous script, you can now schedule same-day appointments assuming those appointments don’t overlap. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing in correctly formatted date/time strings.
Since there isn’t a datetime picker input type, I basically hacked my own using two conditional button inputs.
Demo:
Instructions: This script includes a “variables” section to be as plug-and-play as possible. To customize the script to fit your needs, edit the BaseSpecificNames
values to match your base’s table and field names. Then edit the SCRIPT SETTINGS
values to adjust business hours, appointment time intervals, etc.
You can copy the sample base from the Universe here:
or you can copy the script by itself from the link below: