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

  1. Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    "22") { English_Ordinal = "nd "; } if(This_Day_Date == "3" || This_Day_Date == "23") { English_Ordinal = "rd "; } // display info My_Date.toString("d") + English_Ordinal; How? I'm exploring various methods, so here's a couple using the built-in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    to a string of your choice v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); info v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    } } l_ProductIDs.sort(); v_LastID = l_ProductIDs.get(l_ProductIDs.size() - 1); } // // output info "[" + l_ProductIDs + "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    { v_PublicUrl = r_CreatorDetails.get("data").get("Public_URL").get("url"); } } } } info r_Creator; And here's the 2nd part of the function in CRM // // ************************************************** EBAY...

    • Type: Article
    • Author: Joel Lipman
    • Category: Ebay
    • Language: *
  5. Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

    r_CreateShipment = invokeurl [ url :v_Url type :POST parameters:m_Params.toString() connection:"jl_inventory" ]; info "Created Shipment: "; info r_CreateShipment; if(r_CreateShipment.get("shipment_order") != null) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    the sun Setup a function that generates an access token of the Trading API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  7. ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

    connection:"zcrm" ]; v_MaxCount = ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with a criteria: v_PerPage = 200; v_CountCriteria = "Quote_Stage:equals:Draft"; v_Endpoint =...

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

    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: *
  9. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    - Initial release - Counts opps against this account and updates the field for this opp Date Modified: ??? - ??? More Information: Any information that may help ******************************************************************************* */ // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    = $0020 Const WM_MOUSEACTIVATE = $0021 Const WM_CHILDACTIVATE = $0022 Const WM_QUEUESYNC = $0023 Const WM_GETMINMAXINFO = $0024 Const WM_PAINTICON = $0026 Const WM_ICONERASEBKGND = $0027 Const WM_NEXTDLGCTL = $0028 Const WM_SPOOLERSTATUS = $002A Const...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  11. Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

    year starts in January (Divide by 3 and round up): for each v_Month in l_Months { v_Quarter = (v_Month.toLong() / 3).ceil(); info "Month: " + l_MonthNames.get(v_Month-1) + " :: Quarter: " + v_Quarter; } Yields: Month: January :: Quarter: 1 Month:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  12. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    is not supported in Zoho Creator and nor is List when submitted as a file attachment. sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Testing an attachment" message: "This is a test" attachments: file: input.my_upload ]; //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    type :POST parameters:m_Params.toString() connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount = ifnull(r_Coql.get("info").get("count"),0); } if(!isNull(r_Coql.get("data"))) { v_MatchedAccountID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app needs information from additional apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    = invokeurl [ url :v_Url type :POST files:r_DownloadedPhoto connection:"joel_books" ]; // output response to console info "Response of attempt to upload to Zoho Inventory:"; info r_UploadPhoto; You should get a response similar to the following:...

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

    inventoryItem { id } product { id title handle status createdAt publishedAt updatedAt } updatedAt } cursor } pageInfo { hasNextPage } } } The Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts()...

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

    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: *
  18. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    "user"); m_ThisMessage.put("content", message); l_Messages.add(m_ThisMessage); m_Params.put("messages", l_Messages); //info m_Params; // r_ChatGPT_Request = invokeurl [ url: "https://api.openai.com/v1/chat/completions" type: POST parameters:...

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

    l_AttachmentDetails { m_Attachment = r_Attachment.toMap(); v_Endpoint = m_Attachment.get("href") + "?orgId=" + v_DeskOrgID; info v_Endpoint; // // build data row to send m_Data = Map(); m_Data.put("Ticket ID", p_TicketID); m_Data.put("Attachment ID",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  20. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    + v_RemindTime); m_NewTask.put("Remind_At",m_Reminder); // // check what we're sending info m_NewTask; // // create the task in CRM r_NewResp = zoho.crm.createRecord("Tasks",m_NewTask, m_Blank, "systemcrm"); // // output response of task creation from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 41 - 60 of 132