Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 + o_QuoteDetails.id + ")"); // convert to a usable array var a_QuotedSalesOrders = typeof a_QuotedSalesOrders === "string" ? JSON.parse(a_QuotedSalesOrders) : a_QuotedSalesOrders || []; // set first valid sales order ID var v_FirstSalesOrderID = null;...

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

Php convert filesizes to bytes kb mb gbhttp://mail.joellipman.com/articles/web-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

03 January 2013 Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...

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

MS Excel: Convert a text to a numberhttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now the tricky part, how to copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets...

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

MySQL Updating a database table from another tablehttp://mail.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...

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

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 an MD5 function, like so: v_Etag = zoho.encryption.md5(v_Combined_Fields); // WORKS! Returns a hexadecimal 32 character string Arguably, I'm using Creator 5 and the documentation for the encryption tasks are for Creator v4. However search md5 in zoho...

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

Zoho Deluge: Convert Map to URL Parametershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

Zoho Projects: Deluge to Submit Custom Fieldshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 How? Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it...

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