Desk Reservation app cannot find availability between reservations #117
Comments
|
The filters are correct. The two columns in your reservation list "Check out from" and "Check out to" must be date and time columns WITH "Include Time" ENABLED. By default without the "Include Time" enabled, the date and time columns will only have the date patched by the program when creating a reservation causing the filters to always detect a booking conflict. The Instructions might want to mention this is a requirement when setting up the column |
|
Yes! I figured this out by accident. I changed the format of the column to show the time so I could troubleshoot and all of my bookings started and ended at 12AM. So, the issue was with how the bookings were being created, not the filter. Once I did that, everything worked.
Thank you so much for your reply!
Melissa Muse,
CMP
IT Project Manager
Headquarters
861 Riverland Dr, Charleston, SC 29412
Office: +1 8437628113
***@***.***|CharlestonCountyParks.com
…________________________________
From: Tidomann ***@***.***>
Sent: Friday, August 25, 2023 7:03 PM
To: aprildunnam/PowerApps ***@***.***>
Cc: Melissa Muse ***@***.***>; Author ***@***.***>
Subject: Re: [aprildunnam/PowerApps] Desk Reservation app cannot find availability between reservations (Issue #117)
The filters are correct. The two columns in your reservation list "Check out from" and "Check out to" must be date and time columns WITH "Include Time" ENABLED. By default without the "Include Time" enabled, the date and time columns will only have the date patched by the program when creating a reservation causing the filters to always detect a booking conflict.
The Instructions might want to mention this is a requirement when setting up the column
—
Reply to this email directly, view it on GitHub<#117 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BB7HUXNBKDQFY5V33C6LTGTXXEVLTANCNFSM6AAAAAA3UAB3UI>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
Hi April! I used this template to create a vehicle check out app. My MAJOR bug is that it cannot find availability between bookings. For example, if a vehicle is booked from 9a-10a and also from 2p-3pm, It will not show as available when I search for a vehicle for 12-1pm. Any advice based on the filters that you used?
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: