booking appointments for a mobile car wash facility

[MowahWash]

I am currently in the process of developing an application intended for booking appointments for a mobile car wash facility. I would like the application to incorporate the following alerts:

1. Users should be made aware of any scheduling conflicts if multiple reservations are attempted for the same time and hour.
2. Appointments must be scheduled with a minimum interval of 50 minutes between consecutive bookings.

Your assistance and guidance in implementing these features would be greatly appreciated.

[lynchk21]

1. You can create a virtual column with the type 'Show' to contain your warning regarding multiple reservations. It might read something like

• "Warning: "& COUNT(SELECT(Reservations Table[Reservations ID],AND([Date]=[_thisRow].[Date],HOUR([Time])=HOUR([_thisRow].[Time])))))&" reservations have already been made for "&[Date]& " during the "&HOUR([_thisRow].[Time])&" hour."

You can then set the virtual column to show_if [_this]>0

2. In this case, you can use a vaild_if expression in the [Time] column to determine if the [Time] entered has any of the following conditions:

• [_this]-000:50:00>=MAX(SELECT(Reservations Table[Time],AND([Date]=[_thisRow].[Date],HOUR([Time])=HOUR([_thisRow].[Time])-1))))
• [_this]+000:50:00<=MIN(SELECT(Reservations Table[Time],AND([Date]=[_thisRow].[Date],HOUR([Time])=HOUR([_thisRow].[Time])+1))))
• [_this]+000:50:00<=MAX(SELECT(Reservations Table[Time],AND([Date]=[_thisRow].[Date],HOUR([Time])=HOUR([_thisRow].[Time])))))
• [_this]-000:50:00>=MIN(SELECT(Reservations Table[Time],AND([Date]=[_thisRow].[Date],HOUR([Time])=HOUR([_thisRow].[Time])))))
•  

[MowahWash]

Thank you for your assistance. I have one additional query regarding the implementation of the previously mentioned scheduling features within the context of the following table:

I would greatly appreciate your guidance on how to apply these features effectively.

[AleksiAlkio]

This sample app shows a different approach how to do it and show your booked times. You can find it from appsheet.com/portfolio/77079.