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 is that we have a dropdown/picklist on a CRM invoice record that has the options of "Deposit" and "Final Balance". This rewrites the invoice line items to represent a deposit or a final balance invoice with the deposit deducted. Because these line items...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks...

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

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 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 rewrite this: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] ,...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 - Consider using IECapt (problem with modals/lightboxes - IECapt only sees the dark background and not the modal) - Rewrite whole program to use COM/DOM/AHK: Would suppress website error notifications, reduced code, read webpage content, check when page...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 Authenticate on page load by checking timestamp in token file: If token is required, redirect user to Consent page and rewrite token file (in JSON). If token is not required, use access_token stored in file. It is assumed that you have already...

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

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

23 June 2025 (~100 pages) and gave it the following prompt: Attached is a transcript from a training session on [Topic] - Day 3. Can you rewrite this using headings and punctuation so that it makes sense to other trainees reading it? Rephrase where necessary and...

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