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 This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 2011-03-23 08:00:00.000 Test2 Room 08:00:00 09:30:00 2 Note that [Test1 Room] will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 = 0; v_UserProfile = ""; l_DisallowedProfiles = List({"Agent"}); l_DisallowedOptions = List({"New Lead","Appointment Booked","Lead Confirmed"}); // // capture event m_Webhook = crmAPIRequest.toMap(); // // check if user info is provided...

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