# Help with a Booking App

**URL:** <https://community.glideapps.com/t/help-with-a-booking-app/43919>\
**Category:** Ask for Help\
**Created:** [July 5, 2022, 5:18pm UTC](https://community.glideapps.com/t/help-with-a-booking-app/43919 "2022-07-05T17:18:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alanestevao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alanestevao/32/44606_2.png) [@alanestevao](https://community.glideapps.com/u/alanestevao)\
**Post date:** [July 5, 2022, 5:18pm UTC](https://community.glideapps.com/t/help-with-a-booking-app/43919/1 "2022-07-05T17:18:07Z")

</div>

Hi, I’m new to Glide and I need help with my first app.

I’m building an app for booking rooms and I have two tables: **Rooms** and **Bookings**.

When the user choose a room and click the button to book a room, I set a value in **Rooms** to mark that room was selected and then, I can use a relation in **Bookings** to link the two tables. When the booking is done, I reset this value in **Rooms**.

The problem is that sometimes, users can open the screen for booking, click the button, but not complete the process. So, the value is not reseted and could cause confusion with other booking, because two or more lines will have the default value to make a relation with **Bookings**.

Here’s a link for my app, it’s in portuguese, but I hope you could understand the problem from the text:

> **[Reserva de Salas Carmais](https://acceptable-cook-5055.glideapp.io/)**

---

<div class="post-metadata">

**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:** [July 5, 2022, 5:49pm UTC](https://community.glideapps.com/t/help-with-a-booking-app/43919/2 "2022-07-05T17:49:03Z")

</div>

Hola!

Are you using user-specific column to hold your data during process? It looks that not.

The booking Apps are one of most complex to develop or maintain, don’t feel sad during its development.

Saludos!

---

<div class="post-metadata">

**Author:** ![alanestevao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alanestevao/32/44606_2.png) [@alanestevao](https://community.glideapps.com/u/alanestevao)\
**Post date:** [July 5, 2022, 6:19pm UTC](https://community.glideapps.com/t/help-with-a-booking-app/43919/3 "2022-07-05T18:19:24Z")

</div>

Yes, I’m using a user-specific column to store the value 1 in **Rooms**. Then I compare this value in **Bookings** and make a relation to get which room was selected.

But the same user can select different rooms and not finish the process of booking. Then, various rooms will have 1 in the column. I think I need a way to reset this value when the user go back to the previous screens.

---

<div class="post-metadata">

**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:** [July 5, 2022, 6:44pm UTC](https://community.glideapps.com/t/help-with-a-booking-app/43919/4 "2022-07-05T18:44:37Z")

</div>

Hola de nuevo…

Well, I did my logic in the opposite direction 😉: I look for if a room is available for the selected date and then, if everything is ok, open my form and request the user data to close the booking.

I think this flow is more effective and easier to create/maintain. This is my version if you want to take a look at it:

[https://hotel-v2.glideapp.io](https://hotel-v2.glideapp.io/)

Saludos!