- 1. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM
- / Zoho /
- ... = ""; // // the generic signature for all users with merge fields enclosed with square tags: v_RecodedSignature = " [AB-StaffName] [AB-JobTitle] [AB-MobilePhone] [AB-Email] www.joellipman.com ...
- Created on 05 December 2023
- 2. Zoho Deluge: Zoho Bookings Get Available Slots
- / Zoho /
- ... r_Staff in l_Staff { if(!isnull(r_Staff.get("id"))) { v_StaffName = r_Staff.get("name"); } } Get the Available slots: // // get available slots r_AvailableSlots = zoho.bookings.getAvailableSlots(v_ServiceID,v_StaffID,v_ThisDate.toString("dd-MM-yyyy"),"joels_connector"); l_AvailableSlot ...
- Created on 23 June 2021
- 3. MySQL parameters in Excel 2007 PivotTables
- / MySQL /
- ... table for just the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE ...
- Created on 24 August 2011