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 the custom fields of the line items. Pretty much a function which took me a day to write. Why? As mentioned, it took me a while to write and I would like to use it as a reference for when I forget how to do this. The use-case here is that we have a...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 record based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as Notes, Attachments, Emails, and Timeline should remain. Code will be needed as a layout...

• 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 = Model("/Users//vosk-models/vosk-model-small-en-us-0.15") rec = KaldiRecognizer(model, wf.getframerate()) transcript = [] while True: data = wf.readframes(4000) if len(data) == 0: break if rec.AcceptWaveform(data): result = json.loads(rec.Result())...

• 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 next to "Invoices" in the left sidebar? This script will map over the core fields, address, and line item. This took me a while to get the right syntax for writing to the invoice line items as well as setting the value of lookup fields so I thought it...

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

ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 account and then to reconcile these. This particular case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working. How? First let's go through a resolution and get the official response on what impact...

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

Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 I'd put how I resolved this here. The issue is basically that you want the background to stay in its position in the browser while the rest of the elements scroll about. Go to Extensions -> Template Manager> Edit the CSS for the template You should be...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes for one thing. So let me...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) DETERMINISTIC BEGIN DECLARE iStart, iEnd, iLength int; WHILE Locate( '', Dirty, Locate( '', Dirty, Locate( '

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

Deserialization and cannot checkout files in TFShttps://www.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution Explorer Go to File » Source Control » Go Online The "Go...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Error 404 Component Not Found when enabling SEF URLshttps://www.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 So I'm getting an error like this: The requested page can't be found. An error has occurred while processing your request. You may not be able to visit this page because of: - an out-of-date bookmark/favourite - a mistyped address - a search engine that...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a while. This is for error...datatype {0} is not the same as list datatype {1}...

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