Asset Reservations: No Double-Booking

[Kamille_Parks]

Use Case: You have a table of assets (library books, conference rooms, etc.) that you want people to reserve, but don’t want people to be able to reserve an individual asset at the same time it has already been reserved.

Solution: No-Conflict Asset Reservations script by Kamille. This script allows you to schedule a new asset reservation in a form-like interface by setting a date range, then selecting from a list of assets which are un-reserved for that time period.

Potential Users: Event Planners, Inventory Managers, Librarians, etc.

---

Demo:

drive.google.com

No-Conflict Asset Reservations - Demo Video.mov (video)

Google Drive file.

---

Special shoutout to @Jeremy_Oglesby for his wonderful Detect Scheduling Conflicts script, which inspired me to make my own script. Using both scripts together, I think Airtable users will never have to worry about double-booking an asset again!

---

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. If you’re combining this script with the Detect Scheduling Conflicts script, only BaseSpecificNames section is necessary, but make sure to include all variables.

You can copy the sample base from the Universe here:

Airtable

No-Conflict Asset Reservations - Airtable Universe

This simple base allows you to reserve an asset (i.e. library book, conference room, company property, etc.) for a given time frame. More impressively, it...

or you can copy the script by itself from the link below:

github.com

thekamillionaire/airtableScripts/blob/master/No-Conflict Asset Reservations

/*
Script: No-Conflict Asset Reservations
Author: Kamille Parks

This script allows you to reserve an asset for a specified time period, but only during a between dates when 
there are no existing reservations for that asset. Follow the prompts to select a time period, and then selct 
from a auto-filtered list of the assets available for that time period. You'll never have to worry about 
double-booking an asset again!

Note: This script was heavily inspired by Jeremy Oglesby's "Check for Speaker Schedule Conflicts" script. 
As such, this script uses a similar structure for variables, defined as BaseSpecificNames.

*/

// Begin BASE SPECIFIC NAMES Section (adjust these values to fit your base!)

const BaseSpecificNames = {
    // Reservations Table
    reservationsTable: "Reservations", // name of the [RESERVATIONS] table
    assetField: "Room", // name of the link-type field connecting to the [ASSETS] table

This file has been truncated. show original

[tmalan]

What is your plan for deploying a script like this in AirTable?  I was hoping to use a public link that i could share but public links disable scripts.  How would you get a booking system like this out to the customers?