Search - Joel Lipman .Com

1. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... CHARINDEX(@Delimiter, REVERSE( @Haystack )) -- yields "8" SELECT SUBSTRING(@Haystack, CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields ".String2.String3.String4" Not quite ...; Created on 28 January 2013
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... t = v_SignType; // // Specify template ID // check URL for mail merge template: https://writer.zoho.eu/writer/open/ 0) { v_Filename = v_Filename.subString(0,v_Filename.lastIndexOf(".")); } r_ZS_Download.setFileName(v_Filena ...; 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 /; ... are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index ...; Created on 22 July 2024
5. 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
6. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... for(var index in recordArr){ v_GreetingName = recordArr[index].Nick_Name; break; } ...; Created on 14 March 2024
7. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... = ifnull(c_Document.File_field,""); // // used for blocking certain file extensions (not used in this function) v_DocExtension = v_DocFileName.subString(v_DocFileName.lastIndexOf(".") ...; Created on 26 January 2024
8. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
9. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... = Map(); for each index v_AddressIndex1 in l_CrmBillingAddress { m_BooksBillingAddress.put(l_BooksAddress.get(v_AddressIndex1),r_QuoteDetails.get(l_CrmBillingAddress.get(v_AddressIndex1))); } v_EndpointBillin ...; Created on 18 September 2023
10. Zoho Deluge: Proper Case for Names: / Zoho /; ... each v_Prefix in l_ExceptionPrefixes { if(v_LastNamePart.indexOf(v_Prefix)==0) { v_LastNamePart = v_LastNamePart.replaceFirst(v_Prefix,v_Prefix + " :|JOEL|: ", true).proper(); v_LastNamePart ...; Created on 13 July 2023
11. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting ...; Created on 06 July 2023
12. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... that shipment is not created. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling ...; Created on 27 April 2023
13. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 29 March 2023
14. 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
15. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 01 March 2023
16. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html - ...; Created on 28 February 2023
17. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... */ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = ; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex ...; Created on 08 February 2023
18. ZohoCRM: Import Attachments: / Zoho /; ... := v_FilesTotal + 1 RowNumber := A_Index ;get first selected row RowChecked := LV_GetNext(RowNumber - 1 , "Checked" ) If ( RowNumber = RowChecked ) { v_FilesCopied := v_FilesCopied ...; Created on 16 January 2023
19. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // other fields to fill in for this subform row v_RateCardDisp = v_RateCard.indexOf(" (")>0 ? v_RateCard.substring(0, v_RateCard.indexOf(" (")) : v_RateCard; json_Arg.Rate_Change_Notes = v_RateCardDisp; ...; Created on 09 December 2022
20. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... my list to populate l_CheckDates = List(); // // loop through generated list and add dates for each index v_Index in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } ...; Created on 21 October 2022