Hi April I have your app customized to manage pool cars and it works well, 1 issue is that if a Car is booked out for 3 days, the App is showing the car as available to others on the first and last day, so when someone else sets their date to the same start date they can book the Car.
Please help as I just rolled this app out to our Purchasing division.
This is the current filter
Filter(
Sort(col_Desks,Title),
Not(
Title in col_Reservations.'Car Info'
) && Active = 1 && Or(DeskSearchFilter.Text in Title , DeskSearchFilter.Text in Description)
)
// 'Check Out From' <= startTime && 'Check Out To' >= endTime
/
Filter(
col_Desks,
Not(
Title in col_Reservations.DeskText
) && Active = 1
)
/
Hi April I have your app customized to manage pool cars and it works well, 1 issue is that if a Car is booked out for 3 days, the App is showing the car as available to others on the first and last day, so when someone else sets their date to the same start date they can book the Car.
Please help as I just rolled this app out to our Purchasing division.
This is the current filter
Filter( Sort(col_Desks,Title), Not( Title in col_Reservations.'Car Info' ) && Active = 1 && Or(DeskSearchFilter.Text in Title , DeskSearchFilter.Text in Description) ) // 'Check Out From' <= startTime && 'Check Out To' >= endTime / Filter( col_Desks, Not( Title in col_Reservations.DeskText ) && Active = 1 ) /