Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming lastname is required, the following 10 results were found.

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

    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 barrelled first names...

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

  2. Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-task-timesheet-reminder.html

    { // loop through active users if(r_User.get("status") == "active") { v_Email = ifnull(r_User.get("email"),""); v_LastName = ifnull(r_User.get("last_name"),""); // // single out this person (can be removed after testing)...

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

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

    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 m_Blank = Map(); // // send the request r_Create =...

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

  4. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    // last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given v_CrmContactLastName = ifnull(m_XeroContact.get("LastName"),"-Unknown-"); m_CrmContact.put("Last_Name",v_CrmContactLastName);...

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

  5. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    // last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given v_CrmContactLastName = ifnull(m_XeroContact.get("LastName"),"-Unknown-"); m_CrmContact.put("Last_Name",v_CrmContactLastName);...

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

  6. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    into a map so values can be accessed by key. v_InputData = "{" + "\"ID\":\"TEST-1001\"," + "\"FirstName\":\"John\"," + "\"LastName\":\"Doe\"" + "}"; m_InputData = v_InputData.toMap(); info m_InputData.get("ID"); // yields "TEST-1001" This pattern can be...

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

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

    $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 u.TeamID='$t_value' ORDER BY...

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

  8. 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-crm-zoho-bookings-full-name-appears-in-last-name.html

    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 default in Zoho Bookings...

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

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

    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; } v_QuoteDate =...

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

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

    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 'Wednesday' WHEN 3...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 10 of 10