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

08 November 2018 "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
• Language: *

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 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
• Language: *

Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 } } 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
• Language: *

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 { 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: Zoho
• Language: *

Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 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
• Language: *

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 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
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 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
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $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: *

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 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
• Language: en-GB

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 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
• Language: *

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 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
• Language: *

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 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
• Language: *

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 = 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
• Language: *

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 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
• Language: *

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 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
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 "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
• Language: *

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 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
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 + 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
• Language: *

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 m_Blank); v_BooksItemRate = ifnull(m_BooksItem.get("rate"),0.00); v_ThisQuantity = ifnull(m_LineItem.get("quantity"),1); info "Line Item Rate: " + v_BooksItemRate; info "Line Item Quantity: " + v_ThisQuantity; // if(m_LineItem.get("pricebook_id") !=...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 Lipman) - Clients wants a public URL for Survey: Need this webhook to create contact/account on-the-fly if needed. More Information: Within Zoho Surveys, configure the webhook to return the Response ID, Email, and Survey ID: 1. Login to Zoho Surveys 2....

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