Zoho Deluge: Check Time Booking Slots

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.

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;
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)

Related Articles

Joes Revolver Map

Joes Word Cloud


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:

Donate to Joel Lipman via PayPal

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