Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 the milliseconds into 5 numbers and get the remainder from dividing it by 26 (modulus)... This is NOT to be used for Booking Retrieval Codes as it is easy to determine what code if you have the date/time of the booking as well as the customer's surname...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Check Time Booking Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 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:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 other words, if there are 10 people in a department/team, and 8 people have booked tomorrow off, prevent a 9th team member booking tomorrow off. Why? I've written this article as it took a while to achieve. The Zoho People application and its API are...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 or replace with whatever character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Zoho Deluge: Zoho Bookings Get Available Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

23 June 2021 This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form to allow customers to make a booking based on the configuration...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this enabled without applying the fix. So...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Copy Subform to other Subformshttps://joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 article on a snippet of code which copies one subform to other subforms in the same form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which copies it...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 spend so long the next time I have to do it. The use-case scenario here is that when an appointment is made for a Lead in a booking system, we want a task or call in CRM to popup and remind us that we need to phone this Lead. How? It sounds...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB