ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 for each m_Data in l_Datas { l_QuotedItems = ifnull(m_Data.get("Quoted_Items"),List()); break; } // return l_QuotedItems; }

• 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 ~/.zshrc Test It whisper --help Run the whisper on the original MP3: whisper output_audio.mp3 --model small Error(s): PATH breaks, no commands work: echo 'export PATH="/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Users//Library/Python/3.9/bin"' >...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• 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 a_QuotedSalesOrders[i].Status !== "Expired") { // found one so let's bail v_FirstSalesOrderID = a_QuotedSalesOrders[i].id; break; } } // if not null (was found) then let's assign it to this invoice if (v_FirstSalesOrderID != null) { // retrieve the deal...

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

Format Numbers in AutoHotkey with Commashttps://www.joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

20 September 2011 Result Loop, %OutputVar% { FirstChar:=Substr(Result, 1, 1) IfEqual, FirstChar, `, { Result:=Substr(Result, 2) } else { break } } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the AutoHotkey...

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