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

[Jeremy_Oglesby]

Really nice, @Kamille_Parks!

You utilized those UI elements extremely well, and made your script look and feel approachable and polished!

[Kamille_Parks]

Thanks! This was my first script and a real kick in the butt to make my bases/code more adaptable for others.

I may do a Version 2 of this script to handle date/time.

My little wishlist of features to help me improve this script for Version 3:

• Date Picker-type input
• Ability to share/embed blocks (currently in beta)

[kuovonne]

Great script @Kamille_Parks
I really like your walkthrough video.
I agree on wanting a date picker input type.

[Kamille_Parks]

Kamille_Parks:

My little wishlist of features to help me improve this script for Version 3:

• Date Picker-type input

I came up with a solution to handle times:

No-Conflict Appointment Scheduler Scripting app

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…

[Kamille_Parks]

Surprise! If you thought I was done with this script, so did I. Until I was asked “How would someone reserve more than one asset at a time?”

Here’s how:

github.com

thekamillionaire/airtableScripts/blob/master/No-Conflict Asset Reservations (Multi-asset Edition)

/*
Script: No-Conflict Asset Reservations (Reserve Multiple at a Time!)
Author: Kamille Parks

This script allows you to reserve multiple assets for a specified time period, but only 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: There is another version of the script which allows someone to only reserve one asset at a time available.

*/

// 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
    startField: "Start Date",

This file has been truncated. show original

[Irina_Georgieva]

Hi @Kamille_Parks, thank you so much for sharing, this is priceless!
Question : instead of booking an asset for a date range, can this be used to book specific time range on a selected day?
Something like : start date/ time - end date/ time?
Trying to solve for the rooms no conflict booking for the meetings that are only a few hours, but not set hours if that makes sense.
Thank you.

[Kamille_Parks]

I’m not editing these scripts again. Just use the extension.

Airtable

Scheduler - Apps - Airtable Marketplace

Schedule reservations for people, rooms, or equipment on Airtable with the Scheduler app.

[Irina_Georgieva]

Thank you @Kamille_Parks, would love to add the extension, and, unfortunately, the enterprise account settings do not allow to add third-party extensions. Any tips on how to make it work are greatly appreciated. Thank you.

[kuovonne]

Irina_Georgieva:

unfortunately, the enterprise account settings do not allow to add third-party extensions.

This is the default setting of an enterprise account. I recommend having a discussion with the enterprise admin to see if restricting third party extensions is by design or simply by default. If it is by default, it is a quick change in the admin panel to allow third party extensions. If it is by design, you can ask for their reasoning and work with them to better understand their concerns.