Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 time to find this function, they'll already know this. void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file comes from a Creator form, no InvokeURL needed c_Form = Form[ID...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I add this function to the CRM and use it as a standalone function to upload generic images (such as facebook,...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 what happens in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer visits website to report a faulty product; using website form or chat. Customer can upload or send...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 ohoapis.com/creator/v2.1/data"+zoho.appuri+"report/"+v_ReportLinkName+"/"+v_RecordID+"/"+v_FileUploadFieldName+"/upload?skip_workflow=['all']"; info v_Endpoint; // // upload the file m_Params = Map(); m_Params.put("file", f_TestFile); // // this will...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 to get all products Here we need to loop through all the available pages, so including the above plus some calculation to work out how many times to loop should retrieve every thing: // // initialize l_AllProducts = List(); v_TotalCategories = 0;...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or any other mechanisms within ZohoCRM that allowed me to set up a daily reminder to the lead record owner but to no avail....

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken from the...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was making a...

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 but not for products. How? There may be a better way of doing this. What I'm trying to have is a generic function that will work on any CRM and possibly be quick to adapt to a module other than products. This function will also try to delete the...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 rather than treat the number as a string and truncate it that way. Given the possible options of numbers given, it has to work with every number so here's both in Zoho Deluge Tryout: v_Rate = 12345.545; info "Rate: " + v_Rate; // built-in rounding...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 of your own running PHP 8. The following PHP script was only tested using PHP version 8.x so I can't say whether it will work for previous versions. I cannot take credit for this script, as I asked OpenAI's ChatGPT to write it initially, and to build...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving the instructions here in case it works for you. Pre-amble Requires Homebriew, FFMPEG, PIP, and Python: Open the "Terminal" app Type brew install ffmpeg Extract...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 An article on some Zoho ANSI-SQL (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey....

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

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

09 October 2025 Maps values from the related quote if loaded from somewhere other than converting quote to invoice.". Note that I have a workflow that when saved, uses an auto-number field, pads it with zeros, and prefixes it with "INV-" overwriting the invoice...

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

Confucioushttps://www.joellipman.com/static-items/confucious.html

29 June 2014 a job you love, and you will never have to work a day in your life.

• Type: Article
• Author: Webmaster
• Category: Static Items
• Language: *

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details:...

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

Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click on the...

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

Select unique values in Microsoft Excel columnhttps://www.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically resized in height. What? Basically I have a menu in a...

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