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: *

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 ColumnC ---------- ---------- ----------- Task 1 0.14 1:00:00 Task 2 0.07 0:30:00 Task 3 4.80 34:15:00 Excel needs the decimal number to be representative of a 24 hour slot. In other words, 1.0 in decimal, formatted to time is equal to 24 hours; 0.5...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 116.708333333 39.81111111 116.7083333 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...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 wanted the discount displayed on a template and if they gave 10% discount, it would display as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead,...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the 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...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Another ASCII Extended Character Set for PChttps://www.joellipman.com/articles/microsoft/windows-os/another-ascii-extended-character-set-for-pc.html

14 April 2010 Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 got problems with it not 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) --...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

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

24 October 2014 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 to DECIMAL(12,9) World wide stadiums of more than 40,000 capacity added: 2014-11-05 City...

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

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

27 September 2009 This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card...

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

MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 Float Minimum non-zero values: 2.2250738585072014E-308 8 bytes Maximum non-zero values: 1.7976931348623157E+308 Numeric Decimal Varies Maximum width + 2 bytes String Char Range 1-255 characters Always filled max width String VarChar Range 1-255...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const VK_NUMPAD9 = $69 Const VK_MULTIPLY = $6A Const VK_ADD = $6B Const VK_SEPARATOR = $6C Const VK_SUBTRACT = $6D Const VK_DECIMAL = $6E Const VK_DIVIDE = $6F Const VK_ATTN = $F6 Const VK_CRSEL = $F7 Const VK_EXSEL = $F8 Const VK_EREOF = $F9 Const...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 the request. Usually YOURSERVERNAME\MSSQLSERVER 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) NULL...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 'INT',1,9) random_integer_range, -- testing integer with range UFN_DATASCRAMBLE(1234.567, 'FLOAT') random_float, -- testing decimal UFN_DATASCRAMBLE('ABCDEFGH', 'VARCHAR') random_upper, -- testing uppercase UFN_DATASCRAMBLE('abcdefgh', 'VARCHAR')...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

13 August 2014 Constraint 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....

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 field textVisiblePassword // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date // selectable date time //...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 v_FormattedString = 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";...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 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 / 60; v_TimeHour = ((v_EndTime.toLong() - v_StartTime.toLong()) /...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 may be unnecessary as this could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page to PDF - Used more for links to...

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