# Booking items on date condition

**URL:** <https://community.glideapps.com/t/booking-items-on-date-condition/58246>\
**Category:** Ask for Help\
**Created:** [February 21, 2023, 3:30pm UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246 "2023-02-21T15:30:49Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jerem\_EGN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jerem_egn/32/18467_2.png) [@Jerem\_EGN](https://community.glideapps.com/u/Jerem_EGN)\
**Post date:** [February 21, 2023, 3:30pm UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/1 "2023-02-21T15:30:49Z")

</div>

Hello everyone,

I have a problem and I’m not finding the good way to build my booking Glide Page.  
I have a list of items that I want people to book.  
I want them to fill the beginning date and the ending date of booking and that after that they can choose only the items available in that time period.

Do you know the way to build the data behind this ?  
Many thanks,

Jérémie

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 21, 2023, 11:34pm UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/2 "2023-02-21T23:34:52Z")

</div>

Do you define the availability of items by it not being booked in a certain timeframe?

---

<div class="post-metadata">

**Author:** ![Jerem\_EGN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jerem_egn/32/18467_2.png) [@Jerem\_EGN](https://community.glideapps.com/u/Jerem_EGN)\
**Post date:** [February 22, 2023, 6:11pm UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/4 "2023-02-22T18:11:42Z")

</div>

Yes that what I want.

I found a topic explaining a way to use user specific colums for the start/ end dates and a IF THEN ELSE colum but I’m not doing it well or I am not accurate in the way to do it.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 22, 2023, 11:41pm UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/5 "2023-02-22T23:41:25Z")

</div>

So does your booking involving only dates or are there hours in it too? Let’s say a booking would look like 7AM Feb 23 - 7PM Feb 26 or just Feb 23 - Feb 26?

---

<div class="post-metadata">

**Author:** ![Jerem\_EGN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jerem_egn/32/18467_2.png) [@Jerem\_EGN](https://community.glideapps.com/u/Jerem_EGN)\
**Post date:** [February 23, 2023, 12:01am UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/6 "2023-02-23T00:01:33Z")

</div>

Yes it’s only date.  
But many thanks, I achieve to do it with a previous post !  
Thank you

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 23, 2023, 12:10am UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/7 "2023-02-23T00:10:56Z")

</div>

Hm. You’re not the first one to want this functionality. I’ll build a template this week.Stay tuned.

---

<div class="post-metadata">

**Author:** ![Jerem\_EGN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jerem_egn/32/18467_2.png) [@Jerem\_EGN](https://community.glideapps.com/u/Jerem_EGN)\
**Post date:** [February 23, 2023, 12:29am UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/8 "2023-02-23T00:29:02Z")

</div>

Many thanks

Here is the answer in a previous post that helped me to do it :

> [@Simple Booking overlap Logic using Glide tables](https://community.glideapps.com/t/simple-booking-overlap-logic-using-glide-tables/43321/3):
>
> 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: New rental booking form: start date; end date ; trailer to book view 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…

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 23, 2023, 3:06am UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/9 "2023-02-23T03:06:52Z")

</div>

Something like this?

---

<div class="post-metadata">

**Author:** ![Jerem\_EGN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jerem_egn/32/18467_2.png) [@Jerem\_EGN](https://community.glideapps.com/u/Jerem_EGN)\
**Post date:** [February 23, 2023, 6:13pm UTC](https://community.glideapps.com/t/booking-items-on-date-condition/58246/10 "2023-02-23T18:13:30Z")

</div>

Yes exactly what I did.  
Thanks
