Solved: Delivery booking system - Page 2

Chris_Jeal · 06-12-2019 12:54 PM

Hi,

I would like to add a delivery booking system to my application.
I know that calendar views can be used for this but would there be a way of restricting how many deliveries can be booked in per hour.

For example, my warehouse can accept only 4 bookings per hour, so once 4 have been booked for a particular hour then there can’t be any more scheduled for that hour slot.

Would anyone know how this could be achieved?

Thanks in advance,
Chris.

Derek3

Hi Chris, I looked at the app. Here’s my recommendation to get the base functionality working:

In table Slot Times, change the column header to “Slot Time”. Then regenerate the table.
In table Bookings, add the following show-if formula to “Loading Time” column: ISNOTBLANK([Loading Date])
In table Bookings, change “Loading Time” to type Enum with base Time
In table Bookings, add the following formula into Valid_if field:

SELECT(Slot Times[Slot Time],
COUNT(
SELECT(Bookings[Loading Time],
AND(
[Loading Time]=[Slot Time],
[Loading Date] = [_THISROW].[Loading Date]))
)<4
)

View solution in original post