Search - Joel Lipman .Com

1. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this enabled without applying the fix. So the fix is a setting: Login to Zoho Bookings as the admin ...; Created on 01 September 2021
2. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; What? 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 ...; Created on 23 June 2021
3. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... 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 ...; Created on 09 May 2019
4. Zoho Deluge: Check Time Booking Slots: / Zoho /; 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 ...; Created on 05 December 2018
5. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? 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 ...; Created on 28 March 2023
6. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...; Created on 09 March 2022
7. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; What? 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 ...; Created on 07 December 2021
8. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... figure out so I don't 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 ...; Created on 18 November 2021
9. Zoho Creator: Copy Subform to other Subforms: / Zoho /; What? A quick 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 ...; Created on 17 November 2021
10. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... have already booked the requested dates off. In 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. ...; Created on 10 December 2020
11. Reminder on SSRS row separator: / SQL Server Reporting Services /; My Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each ...; Created on 26 October 2011
12. T-SQL Record Separator: / Transact-SQL /; ... 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 (despite being a timetabling ...; Created on 11 October 2011
13. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; This must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date ...; Created on 04 April 2011
14. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment and features found inside the room. Problem #1: More of an aesthetic problem than ...; Created on 29 March 2011
15. SSRS Expand specific drilldown by default: / SQL Server Reporting Services /; ... is how to do it in SQL Server 2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a ...; Created on 23 February 2011
16. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things until the company implemented a software to deal with room bookings and said we shouldn' ...; Created on 14 January 2011
17. Parameters not being used in report processing: / SQL Server Reporting Services /; ... bookings for a week based on a given date and campus -- =============================================================================== DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId ...; Created on 07 January 2011