Zoho Deluge: Get All Orders from eBayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // now lets loop through a dynamic page list for each v_Page in l_Pages { // // specify which page m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page);...

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

Zoho Inventory: Enable Tracking using the APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory enabled. But to flesh that out a...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 + " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer in l_Customers2 { v_CountDiscrepancies = v_CountDiscrepancies + 1;...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 and website from Organization Details in ZohoCRM. Upload and get publicly-accessible image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I add...

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

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

07 May 2024 articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered for PDF or print...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 soi ON so."Sales order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales Order which was not accurate enough... but here's the...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 from the systems of all partners who store or display that data, including third-party developers integrated with eBay APIs through the eBay Developers Program. To help third-party developers comply with these requests, eBay has implemented a push...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 - 0.001).round(2),v_ListPrice.round(2)); } } Ta daa! Source(s): I would mention a few community forum pages I went through which showed me how not to do it, but as none were the solution, I'm not sure putting them here would make this easier for you....

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 from the quote / if deposit, then don't include the original line items if (v_InvoiceType == "Final Balance") { // now loop through the quoted items / line items for (i = 0; i...

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

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 a tool that every time a new product is added, a thumbnail gets generated and stored in the same application. Trawling through the first few pages of Google, all the online tools that did the same had a pricing page. I can understand why you would need...

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

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 to separately. I want a Zoho Survey when submitted to be parsed by a Zoho CRM REST API function. How? First, I'll go through the steps of setting up the Zoho CRM function, we'll convert it to a REST API function which will give us a URL and then we'll...

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

Zoho CRM: Make Upload File Field Mandatoryhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through the wonders of Zoho CRM Client Script. So we're going to check on page onload, onchange for the Create Page (Standard), Edit Page...

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

Thank You!http://mail.joellipman.com/static-items/thank-you.html

31 May 2009 feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Add "Command prompt from here" to right-click context menuhttp://mail.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools ->...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 by "http://www.notwebdesign.com/joomla-component-creator/". I don't need one because although I rely on data submitted through the forms ($_GET array), all the submitted data on the front-end of my component is controlled and not customizable. I fixed...

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

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation I want the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my...

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

Zoho Deluge - Get Current User IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...

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

Zoho Deluge - Pad with leading Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) {...

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

Zoho Deluge: Generate and Send a CSV via Emailhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime =...

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