Search - Joel Lipman .Com

21. ZohoCRM: Import Attachments: / Zoho /; ... the filename appended. Because of MS Windows 11 limitations (any MS OS really), you need to ensure that long hyphens (#151) and some other funny characters are replaced out as the OS won't allow the file ...; Created on 16 January 2023
22. 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
23. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); info x_Params; // // s ...; Created on 31 March 2022
24. 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
25. 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
26. 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
27. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode ...; Created on 27 January 2022
28. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the ...; Created on 22 January 2022
29. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
30. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: ...; Created on 12 January 2022
31. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
32. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later ...; Created on 19 October 2021
33. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the ...; Created on 13 October 2021
34. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... in case they add a currency or tax rate and want to push a sales order immediately over. Get Currencies Remember to replace the v_BooksOrgID with your client's Organization ID for Zoho Books and ...; Created on 24 September 2021
35. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... / convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send t ...; Created on 20 September 2021
36. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... to yyyy-MM-dd v_RegexdDate = v_TestDate.replaceAll("(\\d)/(\\d)/(\\d)","$3-$2-$1", false); info v_RegexdDate; info v_RegexdDate.toDate(); info v_RegexdDate.toString("E, d MMM yyyy"); info "*********************"; // // ...; Created on 01 September 2021
37. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
38. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... / v_ExchangeRate).toDecimal().round(2); // // format currency with commas (thousand separator) and 2 decimals v_QuoteTotalStr = v_QuoteTotal.toDecimal().round(2).toString().replaceAll("(?" ...; Created on 30 July 2021
39. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the code to verify the webhook came from Shopify: // // declare response variable back ...; Created on 15 July 2021
40. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...; Created on 16 June 2021