Asset Reservations: No Double-Booking

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:


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:

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

9 Likes

Really nice, @Kamille_Parks!

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

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)
2 Likes

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

I came up with a solution to handle times:

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: