Search - Joel Lipman .Com

21. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = ifnull(r_Result.get("Quote_Stage"),"-"); v_QuoteCurr = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime ...; Created on 30 July 2021
22. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... Billable"); v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // // eval v_HoursDecimal = (v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 ...; Created on 30 April 2021
23. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... p_QuoteID is the ID of the quote): // init Map m_UpdateQuote = Map(); // r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID); v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * ...; Created on 20 August 2019
24. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... Production code // v_Latitude1, v_Longitude1 are coords for origin // v_Latitude2, v_Longitude2 are coords for destination v_Latitude1 = v_Latitude1.toDecimal(); v_Longitude1 = v_Longitude1.toDecimal(); v_Theta ...; Created on 11 June 2019
25. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("\b(Posh)([^ ]*)","$1 and $2",false); // yields Posh and David Beckham UK/US Decimal Separator and Commas: v_MyString = 1234.567; v_FormattedString = (v_MyString.round(2)).toString().replaceAll(("(?Link"; v_FormattedString ...; Created on 31 May 2019
26. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
27. Zoho Templates - Font size is inexplicably tiny: / Zoho /; What? This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden ...; Created on 22 February 2019
28. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option) ; decimalPlaces is the number of decimal places to round ; -------------------------------------------------------------------------------------- autoByteFormat(size, ...; Created on 28 January 2019
29. Zoho Deluge - MD5 function: / Zoho /; ... but wouldn't it be nice if you could just replace the base64encode function with an MD5 function, like so: v_Etag = zoho.encryption.md5(v_Combined_Fields); // WORKS! Returns a hexadecimal 32 character ...; Created on 19 November 2018
30. Android: Replace return key with done, go, send...: / AndroidOS /; ... um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter ...; Created on 03 November 2014
31. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... based on country. Future development will associate these with governing bodies rather. Airports/airfields added: 2014-10-26 Military zones lost due to 9 decimal place degrees: 2014-11-05: DB changed ...; Created on 24 October 2014
32. XML Schema Reference: / Extensible Markup Language /; ... for Datatypes Constraint Description enumeration Defines a list of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater ...; Created on 13 August 2014
33. AHK Countdown Tooltip: / AutoHotkey /; ... %A_ScriptDir% ; Ensures a consistent starting directory. SetFormat, float, 0.2 ; Round any floats to two decimals ; ********************************************************************************************************************************************************************** ; ...; Created on 17 July 2014
34. Hide a Drive per User in Windows 7: / Windows OS /; ... drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example: To Restrict B & C, enter ...; Created on 28 March 2014
35. SSIS Convert a string into a date: / SQL Server Integration Services /; ... understanding the last two characters on the row (CR & LF). Fixes of interest: -- assuming This_Decimal="00000.00" or "123456.78" (Do NOT use "Replace" and instead "Add as new column") (DT_DECIMAL,2)TRIM(This_Decimal) -- ...; Created on 14 March 2013
36. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... decimal UFN_DATASCRAMBLE('ABCDEFGH', 'VARCHAR') random_upper, -- testing uppercase UFN_DATASCRAMBLE('abcdefgh', 'VARCHAR') random_lower, -- testing lowercase UFN_DATASCRAMBLE('ABCDefgh', ...; Created on 22 August 2012
37. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... all work. Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft ...; Created on 14 December 2011
38. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal ...; Created on 27 September 2011
39. The ReportServer Database: / Databases /; ... ReportID uniqueidentifier NULL The ID of the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) ...; Created on 08 August 2011
40. Increase Recent Documents Number in Windows XP: / Windows OS /; Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked ...; Created on 28 July 2011