Search - Joel Lipman .Com

1. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products ...; Created on 13 December 2023
2. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... rounding. In other words the following will force the number to have 2 decimal places: v_Test1 = 12; info v_Test1.toDecimal().round(2); // yields 12.00 v_Test2 = 12.0; info v_Test2.toDecimal().round(2); // ...; Created on 08 February 2022
3. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... data. If you are expecting a 3rd comma in the value, then apply the regex again. The Final Solution: The following code is a correction to the above and replaces any commas between two double-quotes ...; Created on 26 August 2021
4. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Personalization Background ms-settings:personalization-background Choose which folders appear on Start ms-settings:personalization-start-places Colors ms-settings:personalization-colors ms-settings:colors ...; Created on 30 July 2020
5. 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
6. Convert foreign characters to English alphabet: / MySQL /; ... working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks "riviere" is different to "rivière". ...; Created on 13 June 2016
7. Excel: convert degrees minutes seconds to decimal: / Excel /; ... I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space ...; Created on 06 November 2014
8. Android: Replace return key with done, go, send...: / AndroidOS /; ... following example replaces the return key with a "GO" key: The XML The Java EditText location = (EditText)findViewById(R.id.editTextLoc); location.setOnEditorActionListener(new TextView.OnEditorActionListener() ...; Created on 03 November 2014
9. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... area at all. Red: Prohibited Area: Do NOT fly in this zone at all! Blue: Location Marker: Represents the area you will be flying in. Green: Model Aircraft Club (the only places you're supposed to ...; Created on 24 October 2014
10. 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
11. Basic Joomla 2.5 Mootools Form: / Joomla /; What? This is an article to demo the crudest form which uses Joomla's version 2.5 core mootools (uncompressed?). This is intended for absolute novices (like me) who just want to see an example of an ...; Created on 20 August 2012
12. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... the overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows ...; Created on 24 January 2012
13. Prices get rounded up in Virtuemart: / Virtuemart /; ... due to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to a currency or two decimal places. ...; Created on 27 September 2009
14. Keyboard and mouse shortcuts in Google Chrome: / Google /; ... Opens the URL in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or Ctrl+E Places a '?' ...; Created on 23 September 2009