I am facing a challenge that seems to be easy to solve, but I can find a work around, thought you guys might have some ideas.
Basically I am creating a booking system for several spaces and resources.
The Basics are simple, One Table where contributors can edit and choose their required date and space. ( ideally displayed in a Detailed View to act as a form or a card to fill )
The table has a button that adds a row to another table where all bookings are collected and deletes the original data from the first table so other contributors can place their own Bookings.
The question is " How to avoid the double bookings ?" Ideally in this case the button is disabled and a text is written underneath the table saying that this space is already booked.
I feel that I am approaching this in a wrong way, I tried the In() and Find() functions but this doesn’t look in each row sequentially. so I end up with finding the space in the space column and the start date in another row.
How can I write a formula that makes it check each row if the space is the same and the time is in between the start and end time then the space is booked, if not check the second row and so on until the end, if nothing is found then the space is free.
here is an example doc of what I mean.h