Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts ...; Created on 11 October 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... d = if(!isNull(m_Result.get("zohosign__Date_Declined")),m_Result.get("zohosign__Date_Declined").toString(v_DateFormat),"-"); v_ZohoSignDoc_LastActivityTime = if(!isNull(m_Result.get("Last_Activity_Time")),m_Result.get("Last_Activity_Time").replaceAll("T ...; Created on 06 August 2024
3. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info ...; Created on 31 July 2024
4. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... loop this to get all the categories // let's calculate how many pages we need v_MaxPages = ceil(v_TotalProducts / v_PerPage); // // generate a loop list l_ProductPages = " ".leftpad(v_MaxPages - 1).replaceAll(" ...; Created on 15 April 2024
5. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name; for each c_Product in l_ApplicableProducts { l_CsvRow = List(); l_CsvRow.add(c_Product.Photo); l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ...; Created on 25 March 2024
6. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = r_Permissions.get("data").get("attributes").get("permalink"); v_ImageURL = v_ImageURL.replaceAll("https://workdrive.zohopublic.eu/file/","",true); // // replaced with URL taken on inspect element v_ImageURL ...; Created on 05 December 2023
7. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... ) + "%"); m_BooksLineItem.put("item_total",r_CrmLineItem.get("Net_Total").toDecimal().round(2)); v_CrmVatPercent = r_CrmLineItem.get("VAT2").replaceAll("[^0-9]",""); v_BooksTaxID = ifnull(m_Taxes.get(v_CrmVatPercent),m_Taxes.get("20")); m_BooksLineItem.put("tax_id",v_BooksTaxID); m_BooksLineItem.put("tax_percentage",v_CrmVatPercent); break; } } } l_BooksLineItems.add(m_BooksLineItem); } m_CreateEstimate.put("line_items",l_BooksLineItems); // ...; Created on 18 September 2023
8. Zoho Deluge: Proper Case for Names: / Zoho /; ... set first and last name v_FirstName = "BILLIE-JO"; v_LastName = "MCDONALD-O'LEARY ii OF CAMBRIDGE-worcester-OXFORD"; // // let's deal with double or triple barrelled first names v_FirstName = v_FirstName.replaceAll("-", ...; Created on 13 July 2023
9. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... = v_ThisCurrentWeekNumber.leftPad(2).replaceAll(" ", "0", true); // // or // v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("ww"); // // ...; Created on 06 July 2023
10. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
11. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023
12. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
13. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... a list based on the number of days ago (list of dates to check) l_GeneratedList = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // ...; Created on 21 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = 1500; // // now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ...; Created on 01 March 2023
15. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "\"" + v_ProductHandle + "\""; } v_Shopify_Created = v_ProductCreated.getPrefix("Z").replaceAll("T"," "); v_Shopify_PublishedStr = if(!isNull(v_ProductPublished),v_ProductPublished,v_Shopify_Created); v_Shopify_Published ...; Created on 20 February 2023
16. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... with this many spaces using leftpad v_GeneratedList = leftpad(" ", v_CheckDaysAhead).replaceAll(" ",","); // // convert string to a list l_GeneratedList = v_GeneratedList.toList(); // // initialize ...; Created on 21 October 2022
17. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = v_FileDetected.indexOf("_"); v_FilenameDetected = v_FileDetected.subString(v_SubstringStart + 1); v_FilenameFormatted = v_FilenameDetected.replaceAll("_"," "); row.Document_Name=v_FilenameFormatted; } } ...; Created on 11 March 2022
18. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... = m_Offset.get(input.Calendar_Day_Select.replaceAll("[^0-9]","")); // // if a number was selected, ie. not chevrons if(v_DateOffset >= 0) { // // set selected date field value input.Selected_Date ...; Created on 09 March 2022
19. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", ...; Created on 08 February 2022
20. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString = thisapp.DataCleansing.fn_DecodeHtmlEntities(v_TestString); info ...; Created on 27 January 2022