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

07 May 2024 +44 (0)1234 567890 info@mycompany.com www.mycompany.com QUOTE Quote For: Quote Date: Quote By: Item Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity =...

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

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc..."). function getTimeAgo($p_Date) { // get seconds ago $v_Seconds =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

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

13 December 2023 will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to round this up manually and then save the...

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

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

24 October 2014 v1.7.x [16 Nov 2014] - [1.7.3] Map: toggle zoom in/out - [1.7.3] Map: toggle animations - [1.7.3] Pilot: preferred weight unit (grams / pounds) - [1.7.3] Pilot: preferred dimension unit (cm / inch) - [1.7.3] Pilot: preferred distance unit (m+km / ft+mi)...

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

Zoho Deluge - Get distance between two coordinateshttps://joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" Version 2019 string fn_getMilesBetweenCoords(float p_Lat1, float p_Lng1, float...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 m_Variant.put("title",input.Listing_Title); m_Variant.put("sku",input.Product_SKU); m_Variant.put("price",input.Shopify_Unit_Sell_Price); m_Variant.put("taxable",input.Taxable); m_Variant.put("inventory_quantity",input.Quantity.round(0)); // deprecated...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 m_CrmProduct.put("Description",m_XeroLineItem.get("Description")); m_CrmProduct.put("Unit_Price",m_XeroLineItem.get("UnitAmount")); // // map over tax (even if it's zero) v_XeroLineItemTaxAmount = ifnull(m_XeroLineItem.get("TaxAmount"),0).toDecimal();...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 { m_CrmProduct.put("Description",m_XeroLineItem.get("Description")); } m_CrmProduct.put("Unit_Price",m_XeroLineItem.get("UnitAmount")); // // map over tax v_XeroLineItemTaxAmount = ifnull(m_XeroLineItem.get("TaxAmount"),0).toDecimal();...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit of the drilldown). What's the problem? Enter this as a query in Excel without the parameters and it will work. Set MySQL...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 but it's coming out really nicely Sparkly! and Shiny Hmm... wrong way round, the compass cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube videos)...

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

Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 }, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock": 0, "total": 0, "id": "1642130000047106029", "product_description": null, "line_tax": [] } ],

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

AutoHotkey: Get Media Information and Displayhttps://joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows 10 but we needed...

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