Zoho Deluge: Check Time Booking Slots

What?
Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking.

How?
Given a date/time and a duration, we will work out the requested start and end time:
req_StartTime = input.Date_Field;
req_Duration = 90;
bool_doubleBooked=false;
for each thisRecord in allRecords
{
	thisRecord_StartTime = thisRecord.req_StartTime ;
	thisRecord_EndTime = thisRecord.req_StartTime.addMinutes(req_Duration);
	if(v_StartDate <= thisRecord_StartTime && v_EndDate >= thisRecord_StartTime)||(v_StartDate <= thisRecord_EndTime && v_EndDate >= thisRecord_EndTime)
	{
		doubleBooked=true;
	}
}

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin - Valid till 8 May 2022 3QnhmaBX7LQSRsC9hh6Je9rGQKEGNQNfPb
© 2021 Joel Lipman .com. All Rights Reserved.