ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 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 module that are calculated and will sometimes return numbers...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 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 be flying). Black: Earthquakes & Extreme Weather: To avoid, or search & rescue (note there are laws...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Type a URL, then press Alt+Enter. Opens the URL in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or Ctrl+E Places a '?' in the address bar. Type a search term after the question mark to perform a search using your default search engine....

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Description enumeration Defines a list of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 Note that negative numbers should be supported. 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 after the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 Why? A content management system (CMS) that I'm 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...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; 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, decimalPlaces =...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 datatype to a decimal first and then use the 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); //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 A lot of forums were suggesting to change the number_format to convert any number to a currency or two decimal places. Another suggestion was to alter the main virtuemart database table (jos_vm_prodcut_price)... Don't do any of these things! After...

• Type: Article
• Author: Joel Lipman
• Category: Virtuemart
• Language: *