How to avoid Book slots double bookings same time and date?

Like (0) Share

Report

Posted on 25 Jan 2024 11:57:34 by SK39

Filter(Sort(col_Desks,Title),Active=1&& Not(// Not reserved for the selected date and time span
Title in Filter(col_Reservations,(DateTimeValue(Text('Check Out From Text',DateTimeFormat.ShortDate)) >=DateTimeValue(Text(startTime,DateTimeFormat.ShortDate))||
DateTimeValue(Text('Check Out To Text',
DateTimeFormat.ShortDate))>DateTimeValue(Text(endTime,DateTimeFormat.ShortDate)))
//&&// Same date)
.Title),MaxCapacity>=CountRows(NameOfPeopleComboBoxNewBooking.SelectedItems)&&MinCapacity<=CountRows(NameOfPeopleComboBoxNewBooking.SelectedItems))

image (1).png

All responses (1)

Answers (1)

Verified answer

SK39 9 on 31 Jan 2024 at 09:15:20

Like (0)

Report

Re: How to avoid Book slots double bookings same time and date?

Not working, same error showing both meeting room same time and date.

I have attached the image also please check.

image (1).png

image.png