Advanced Search

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 joel is required, the following 656 results were found.

  1. Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

    Input: int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    connection:"zcrm" ]; l_SortedProducts = ifnull(r_CoqlSortedProducts.get("data"), List()); Source(s): Joel Lipman - ZohoCRM: Process all records of a module Zoho Deluge - Search Records in Zoho CRM Zoho Deluge - Get Records from Zoho CRM

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not). console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    on Shopify,Published on Shopify"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // app specific v_ShopID ="joels-awesome-shop"; v_ShopifyApiVersion = "2022-01"; v_AccessToken = "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2222"; v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    /* Function: fn_eBay_GetOrders() Purpose: Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoAnalytics: Pivot Campaigns vs Contactshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zohoanalytics-pivot-campaigns-vs-contacts.html

    Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- -------------- Joel Google Ads Accepted Invited Sent Me Web Invited Accepted Sent Myself Walk-In Accepted Sent Invited The catch is that our...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  8. Zoho Creator: Sendmail a list of attachmentshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-send-mail-a-list-of-attachments.html

    missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file comes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-system-values-maps.html

    and Nominal Accounts Inputs: - Outputs: - Date Created: 2021-09-24 (oel Lipman) - Initial release Date Modified: 2024-05-21 (Joel Lipman) - Change of API domain from https://books.zoho.com to https://www.zohoapis.com/books...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  10. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    modified Purpose: Pushes the tickets attachments to Zoho Analytics Inputs: - Outputs: - Scope(s): Date Created: 2023-11-29 (Joel Lipman) - Initial release Date Modified: ??? - ???...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  11. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    { ZDK.Client.openMailer({ from: '', to: [{ email: v_ContactEmail, label: v_ContactName }], bcc: [{ email: 'no-reply@joellipman.com', label: 'Copy for myself' }], subject: 'Greetings from the Joel Lipman team!', body: 'Hi there! I\'m the very model of a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    ZohoBooks invoice directly to its recipient Inputs: Zoho Creator record ID of the order Outputs: - Date Created: 2023-03-06 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: Error 7008: There are no contact persons associated with this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    Sales Order lookup field on the Purchase Order line item. Inputs: salesorder Outputs: Related List Date Created: 2024-07-09 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    page) if(b_ValidResponse) { // // generate HTML page when clicked (please amend the following variables) v_CompanyName = "Joel Lipman Ltd"; v_CompanyStrapline = "The One and Only"; v_CompanyURL = "https://www.joellipman.com"; v_LogoURL = v_CompanyURL +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  15. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void Date Created: 2024-12-10 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    Standalone Purpose: Used to remove duplicate products from a ZohoCRM instance Inputs: - Outputs: - Date Created: 2025-03-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    of the invoice can happen on save Maps other fields to fill in the blanks Inputs: - Outputs: - Date Created: 2025-10-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    on your server.I'm going to refer to the files to create as being in this folder. ./profile5/profile5.php User - Profile - JoelLipman.Com Joel Lipman April 2011 (C) 2011 JoelLipman.Com. All rights reserved. GNU General Public License version 2 or later;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    BIDS and test. the BAT I use to automate this (run as Administrator in Win7 from C:\temp): @ECHO OFF REM This program is for Joel Lipman to run after he's made a change to some REM C# code for a SSIS Custom Script Component task. REM Change the working...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    & " matching record" & IIF(Sum(Fields!myCount.Value, "DataSet2")=1, "", "s") & " found." ) -- Search for Joel Lipman yields "1 matching record found." -- Search for SMITH yields "Displaying the first 100 of 2732 results returned." We would not offer the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 61 - 80 of 656