Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 but the below code sufficed for my current task, common English and some European names: // // set first and last name v_FirstName = "BILLIE-JO"; v_LastName = "MCDONALD-O'LEARY ii OF CAMBRIDGE-worcester-OXFORD"; // // let's deal with double or triple...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND...

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

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

01 September 2021 the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 error: // initialize m_QuoteRecord = Map(); // // build quote request m_QuoteRecord.put("Name.first_name",v_SellerName_Firstname); m_QuoteRecord.put("Name.last_name",v_SellerName_Lastname); m_QuoteRecord.put("Email",v_SellerEmail); // // other params...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 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 WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN...

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

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another Joe TABLE: Qualifications -------------------------------------------------- ID Employee...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 page excluding the content (edited for Public display - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email = c_Quote.Email; }...

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