Search - Joel Lipman .Com

1. Android: Replace return key with done, go, send...: / AndroidOS /; What? A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a ...; Created on 03 November 2014
2. Preg_Replace all strings between two tags: / Personal Home Page /; What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is ...; Created on 07 February 2013
3. Search and Replace in a MySQL Database: / MySQL /; ... but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html ...; Created on 17 March 2010
4. Zoho Creator: Input Color Picker: / Zoho /; ... Step 2: Replace the text with colored boxes // ... // // reset and set radio group options clear input.Color_Picker; for each l_ColorRow in l_ColorPalette { for each v_ThisColor in l_ColorRow ...; Created on 14 October 2024
5. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value ...; Created on 11 October 2024
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... / send an order array l_OrderIDs = List(); m_OrderID = Map(); m_OrderID.put("OrderID",p_eBayOrderRef); l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and repla ...; Created on 27 April 2023
15. 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
16. 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
17. 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
18. 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
19. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / 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 request XM ...; Created on 28 February 2023
20. 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