Search - Joel Lipman .Com

41. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... Line Item Tax does not submit in API v2.1 Trial and error resolved this one. Submit the line item but instead of "line_tax", replace this with "Line_Tax" (note the capitalized letters). I have included ...; Created on 17 May 2021
42. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... 60; v_TimeHour = ((v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 / 60).round(0).leftpad(2).replaceAll(" ", "0"); v_TimeMinutes = ((v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 % 60).round(0).leftpad(2).replaceAll(" ...; Created on 30 April 2021
43. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url": "/crm/org12345678901/specific/ViewAttachment?fileId=aaaabbbbccccddddeeeeffff1111222233334&module=CustomModule1&parentId=123456789012345678&creatorId=987654321098765432&id=234567890123456789&name=dummy1.pdf&downLoadMode=default", ...; Created on 02 February 2021
44. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... = l_Data.toString(); info v_Data; // yields // , Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", true); v_DataHtml ...; Created on 11 January 2021
45. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough ...; Created on 28 August 2020
46. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; What? So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion ...; Created on 14 July 2020
47. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... ; get name of file without its extension v_ThisFileName := A_LoopFileName v_ThisFileName := StrReplace( A_LoopFileName, "." A_LoopFileExt, "") a_ThisFileName := StrSplit( ...; Created on 08 July 2020
48. 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
49. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... in Creator: l_MyMultiPicklist = List(); for each r_PicklistOption in r_DealDetails.get("My_MultiPicklist") { v_PicklistOption = r_PicklistOption.trim().replaceAll(",", ",",true); l_MyMultiPicklist.add(v_PicklistOption); } m_CrmFields.put("My_MultiPicklist",l_ProductCategories.toString()); // ...; Created on 20 April 2020
50. MySQL: Count occurrences of words in a column: / MySQL /; ... of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) ...; Created on 12 March 2020
51. Animated Headlines: Created on 30 November -0001