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 /; ... _ if(!isNull(v_Template.get("templates").get("actions"))) { // get the actions l_Actions = v_Template.get("templates").get("actions").toList(); for each m_Action in l_Actions { if(m_Action.get("action_type") ...; 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 Projects: Get All Events: / Zoho /; ... ")) { l_ThisDateTimeEventParts = m_PastEvent.get("scheduled_on").toList(" "); if(l_ThisDateTimeEventParts.get(0).contains("/")) { l_ThisDateEventParts = l_ThisDateTimeEventParts.get(0).toList("/"); v_ThisDateEvent_Year ...; Created on 22 July 2024
5. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already 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 ...; Created on 07 May 2024
6. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... ",",").toList(); for each v_PageIndex in l_ProductPages { // // products v_EndpointProducts = v_MyWordPressSiteUrl + "/wp-json/wc/v3/products"; // l_PaginationParams = List(); l_PaginationParams.add("page=" ...; Created on 15 April 2024
7. Zoho Deluge: Proper Case for Names: / Zoho /; ... = List(); l_LastNameParts = v_LastName.toList("-"); for each v_LastNamePart in l_LastNameParts { // // default to proper v_LastNamePart = v_LastNamePart.proper(); // // if exception prefixes for ...; Created on 13 July 2023
8. 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
9. 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
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... ", ",").toList(); for each index v_Increment in l_AddPages { l_Pages.add(v_StartingPageIndex + v_Increment); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details ...; Created on 01 March 2023
11. 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
12. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... specified in a previous multi-line text field l_PackageRefs = c_Appt.Associated_Package_Slips1.toList(); // // important to declare this as a list of integers l_PackagesToAdd = List:Int(); for ...; Created on 18 August 2022
13. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... = v_HtmlEntityNames.toList(); l_HtmlEntityChars = v_HtmlEntityChars.toList(); // // add these exceptions (quotes) which wouldn't convert to a list l_HtmlEntityNames.add("quo"); l_HtmlEntityNames.add("apos"); l_HtmlEntityChars.add("\""); l_HtmlEntityChars.add("'"); // // ...; Created on 27 January 2022
14. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = v_SoapAction.toList("/"); v_Type = l_SoapActionParts.get(l_SoapActionParts.size() - 1); } } m_Blank = Map(); m_CreateRecord = Map(); m_CreateRecord.put("Event_Type",v_Type); m_CreateRecord.put("Payload",m_Payload.toString()); r_CreateRecord ...; Created on 20 September 2021
15. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... pure Deluge no Regex v_DelugeDate = v_TestDate.toList("/").get(2) +"-"+ v_TestDate.toList("/").get(1) +"-"+ v_TestDate.toList("/").get(0); info v_DelugeDate; info v_DelugeDate.toDate(); info v_DelugeDate.toString("E, ...; Created on 01 September 2021
16. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list (string delimited by commas) l_StringParts = v_FormattedString.toList(); // ...; Created on 26 August 2021
17. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 ...; Created on 04 May 2020
18. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; ... = v_ReturnedUrl.subString(v_ReturnedUrl.indexOf("?")+1).toList("&"); m_UrlParams = Map(); for each r_Part in l_ReturnedUrlParts { if(r_Part.contains("=")) { l_ParamParts = r_Part.toList("="); m_UrlParams.put(l_ParamParts.get(0), ...; Created on 09 March 2020
19. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... to split a string into a list by the backslash character: v_File = "C:\Documents\My_File.txt"; // want to extract My_File.txt l_FileParts = v_File.toList("\\"); info l_FileParts.get(l_FileParts.size() ...; Created on 06 February 2020
20. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = "12345"; l_StringValues = v_MyString.replaceAll("(?)",",",false).removeFirstOccurence(",").removeLastOccurence(",").toList(); // yields list of [1,2,3,4,5] // NB: "1mySep2mySep3mySep4mySep5".toList("mySep"); // ...; Created on 31 May 2019