Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Double booking - in combination with several day booking #136

Open
Proesel1 opened this issue Mar 10, 2024 · 1 comment
Open

Double booking - in combination with several day booking #136

Proesel1 opened this issue Mar 10, 2024 · 1 comment

Comments

@Proesel1
Copy link

Hello,
for me its possible to generat double booking if one person books more than one day and the second is booking the first day or the last day of this booking.

E.g.
Person 1 books 10.03 - 16.03 (Desk 1)
Person 2 can book Desk 1 on 10.03 and 16.03.

For 11-15.03 Desk 1 is not available.

image

I guess this is a filter failure from "DateSelection"

I have some problems to fix this and hope some of you can help me here.

Thaks a lot
Bernd

@plarochette
Copy link

Hey, i had the same problem. You have to set an option in the sharepoint list to extend the format to Date + Time for "Check Out From" and "Check Out To"

In French>
image

The aim is to satisified this code implemented in the confirmation button to return correct reservation with the correct time/hour in compare opérations

ClearCollect(
col_Reservations;
Filter(
'Desk Reservations';
Or(
And(
'Check Out From' >= startTime;
Or(
'Check Out To' <= endTime;
'Check Out From' < endTime
)
);
And(
'Check Out To' > startTime;
Or(
'Check Out To' <= endTime;
'Check Out From' < endTime
)
)
)
)
);;

Best regards

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants