# Search availabe rentals for a given date range **URL:** \ **Category:** Ask for Help\ **Created:** [October 9, 2021, 2:07am UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841 "2021-10-09T02:07:06Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![AlexA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexa1/32/15534_2.png) [@AlexA1](https://community.glideapps.com/u/AlexA1)\ **Post date:** [October 9, 2021, 2:07am UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841/1 "2021-10-09T02:07:06Z")
Glider, I´m having a bad time trying to solve this, already tried different approaches (query formula is one), and I´ve not achieved my requirement please help! Let me give you a bit of context. I have three tables: • Item Type: Stores the available categories or models of the items. • Items: Stores the actual items in stock (each one of them has an atribute “item type” • Reservations: Stores bookings to use a certain amount of a particular or multiple types of items within a date range. I would like to generate a View/search table that contains the amount of available type of items given a start (SD) and end (ED) date that the user states for a posible reservation, so the user can add available items to reservation. The table would look like this Type: The type of item. Amount available: Item[Item\_type == This row type].count - Reservations[SD\current\_posible\_reservation.SD && item\_type cointains This row type].thisrow\_item\_type.count This way, the customer can preview which types of items are available for reservation. Think would be quite similar to a clasic car rental, like this. ![image 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a51dab9bbef52c67a44f43e595e00d574143886.jpeg) Help! ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [October 9, 2021, 11:33am UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841/2 "2021-10-09T11:33:00Z")
Hi @AlexA1 @gvalero Has been working on something similar. Take a look. [https://hotel-v2.glideapp.io/](https://hotel-v2.glideapp.io/) ---
**Author:** ![AlexA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexa1/32/15534_2.png) [@AlexA1](https://community.glideapps.com/u/AlexA1)\ **Post date:** [October 9, 2021, 6:38pm UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841/3 "2021-10-09T18:38:44Z")
Thanks! I just gave a look to the app. Looks like that is what I´m looking for. @gvalero Can you send screenshots or explain me how did you organized the database and the logic on top? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [October 10, 2021, 5:25pm UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841/4 "2021-10-10T17:25:02Z")
Hola @AlexA1 Sorry for my delay, I have been sick these days. As soon as I feel better I will show some screenshots and explain what I did. My APP has some EC columns to get what you saw. Saludos ---
**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:** [October 10, 2021, 11:25pm UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841/5 "2021-10-10T23:25:36Z")
Hope you feel better soon bro! ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [October 29, 2021, 1:23pm UTC](https://community.glideapps.com/t/search-availabe-rentals-for-a-given-date-range/32841/6 "2021-10-29T13:23:33Z")
Hola @AlexA1 Do you still need some help with your APP? Saludos