I am working on a booking system for bikes.
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!