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 firstname 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

    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 Deluge
    • Language: *

  2. 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 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 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

    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 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

    } } } // // build upsert for CRM contact m_CrmContact = Map(); m_CrmContact.put("First_Name",m_XeroContact.get("FirstName")); // last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given 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

    } } } // // build upsert for CRM contact m_CrmContact = Map(); m_CrmContact.put("First_Name",m_XeroContact.get("FirstName")); // last name is mandatory for a CRM contact so we're going to put a placeholder one if this is not given 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

    lines, then converts it 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...

    • 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

    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

  8. 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

    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 Creator
    • Language: *

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

    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

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

    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
Results 1 - 10 of 10