Share
Report
33Hi Community,
I have created a desk booking app that allows users to book a workspace for either a AM,PM or all day slot. I now need to create an edit screen that allows the user to amended/update the booking. I have hit a snag on how best to achieve this, my code as it stands is below.
If(
CountRows(
Filter(
'Desk Booking',
Date = Text(DatePicker3.SelectedDate,"dd/mm/yyyy") && Value(CurrentBookings.Selected.BeginTime) = TimeValue(Dropdown3.Selected.Value)&& CurrentBookings.Selected.FinishTime = Dropdown4.Selected.Value && Value(CurrentBookings.Selected.FinishTime) >= TimeValue(Dropdown3.Selected.Value)
)
)|| CountRows(Filter('Desk Booking',Desk= CurrentBookings.Selected.'Desk ' && Date = Text(DatePicker3.SelectedDate,"dd/mm/yyyy")))=2|| CurrentBookings.Selected.BeginTime=Dropdown3.Selected.Value && CurrentBookings.Selected.FinishTime=Dropdown4.Selected.Value || Value(CurrentBookings.Selected.FinishTime)<TimeValue(Dropdown4.Selected.Value),
"Not Available",
"Available"
)
It is partially working but if a person books an all day slot and then wants to amend the booking to an AM slot the label shows "Not Available", does anyone have any better ways of achieving this.
Many thanks
All responses (
Answers (
