Booking Items - Check availability

[Yosh]

Hey community,
I am working on a booking system for bikes.
Bike Booking

To make it simple for my team, I would like to use the Airtable forms as a booking form.
(See “Bookings” -> “Bookings-Munich” form)
When a customer calls to book one or more bikes, we want to use this form and fill name, start-date, end-date. (I use “Munich” as a default location on this form, as logic jumps aren´t supported in airtable forms…)

With “Bike-Selection” (linked record to BIKES table) i set "limit records selection to view "Bookable-Munich). Then i get a list of bikes.

The problem i have, how to avoid bookings on the same day(s).
Using the form, set start-& end date, i have no clue how to filter/show only bikes which are available (location Munich) on or between that specifics date(s)…

Any ideas? Is it possible with a airtable form at all?
Or do i have to use a a special formula?
Any help would be great!
Thanks

Yosh

[andywingrave]

Hey Yosh!

I think this forum post should answer your question!

Availability Check Ask the community

Hi All, I’m banging my head up against the wall trying to figure this one out. Hopefully someone out there will be able to help. I have a base that is similar to a hotel or airbnb. So there are bookings, checkins etc. When someone calls in to see if there is any availability for a specific date with a specific room type, there needs to be some sort of quick check. A Check Availability sheet was created whereby an admin enters in preferred room type along with required start and end dates. …

Hope it helps!

[Kamille_Parks]

I wrote two scripts which do do this using the Scripting Block. They don’t use Form Views though.

Asset Reservations: No Double-Booking Scripting app

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. [Screen Shot 2020-03-20 at…

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…

[Yosh]

Thanks @Kamille_Parks & @andywingrave !
Will check it out!