Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { // init v_DateTill= "-"; v_QuoteTotalDisp= "-"; v_Index = v_Index + 1; v_RelatedListXML = v_RelatedListXML + ""; // // retrieve v_CreatorQuoteID = r_Result.get("ID");...

• 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 retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map();...

• 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 the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm applying to a...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 = m_TranslateStatuses.get(m_ThisInvoice.get("Status")); if(m_ThisInvoice.get("Status") == "PAID") { v_InvoiceTotal = m_ThisInvoice.get("Total"); v_PaidTotal = 0.0; // we have a partially paid status in crm so let's check those payments for each...

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

Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 // yields 30 And if working with money/currencies, a one liner to maintain the decimal point v_SalesAmount = "Total : £ 5.00"; v_SalesAmount = v_SalesAmount.replaceAll("[^0-9.]",""); // yields 5.00

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