Simple Booking overlap Logic using Glide tables

Hi Darren, thanks for getting back to me

That could work - could you please guide me on how to build the logic for this. i already have the following:

  1. New rental booking form: start date; end date ; trailer to book view
  2. ive implemented the caching option whereby the user’s start and end dates are recorded into the caching table (so that i could validate it but i have not managed to figure this out)

i would need to give the customer the option to open for example the next 30 days for booking in advance. alot of customers will arrive and book for the day so we will need to at any point know whether a trailer is available or not.