AnsweredAssumed Answered

Validating Schedule Times

Question asked by NickUlrich on Apr 29, 2013
Latest reply on Apr 29, 2013 by philmodjunk

Title

Validating Schedule Times

Post

     Hey all,

     This forum has given me a ton of great advice in the past... hoping for a little bit more!

     I'm adding a section to an existing database that includes scheduling for our deliveries. The design has been relatively simple, but I can't think of a way to Validate the entries in a way that times are "blocked" such that you can't accidentally double-book a spot of time.

     Fields:

     Destination

     Departure Time

     Time Blocked

     End Time (calc: Departure Time + Time Blocked)

      

     Basically, if I schedule a delivery at 8am with 30 minutes blocked for it, the next availble time would be 8:30. I want to generate an error if someone tries to schedule a delivery between 8 and 8:30 or schedules a delivery with an end time between 8 and 8:30. This strikes me as needing some clever math more than anything.

     The database is already script heavy so it really doesn't matter whether this uses field validation or is scripted out. I'm open to any and all ideas.

      

     Thanks in advance!

Outcomes