Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note...

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

AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; Skips the prompt that a current instance is running and overwrites this one with a fresh instance of this program SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a...

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

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 openMap(v); // do function on pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No...

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

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8'); mb_http_output('UTF-8'); mb_http_input('UTF-8'); This does nothing: // add the following to your header This does nothing: // set the collation of the database and...

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

AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 and compatibility with future AutoHotkey releases. #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 subroutine for when listview row is double-clicked to open Chrome Browser with selected Profile. #NoEnv #Warn SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance force ;...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ;...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 . = ; . = ; // insert the row into the collection .insert( ); // insert the collection into the subform on the current form input..insert( ); // or insert the row(s) into the subform through the record variable r_LeadDetails = Leads[ID == 1234567890];...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 Creator page, retrieve the title and content of the modal dialog from the record by using the following: v_NotifyID = ifnull(input.p_NotifyID,0).toLong(); r_NotifyDetails = Notifications[ID == v_NotifyID]; v_Text = r_NotifyDetails.Title; v_Content =...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params I'm calling...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 m_Link); } Code to Add a value to a multi-lookup (on Update Record): v_DealID = ifnull(input.p_DealID,0); if(v_DealID != 0) { m_Link = Map(); m_Link.put("Deal", v_DealID); m_Link.put("Product", 123456789012345678); r_Link =...

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

Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 any bidirectional relation field that exists will be prepopulated using the method above. Clear subform of all its rows: input..clear(); Changing the picklist/dropdown options in a subform row (applies overall rather than per row): clear ..; ..

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

Zoho Creator: Receive eBay Notification and Create Shopify Orderhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-notification-and-create-shopify-order.html

21 January 2022 Transaction data and then the code to create a Shopify Order: Parse an eBay Transaction Notification (XML) x_ResponseBody = input.Payload.getJSON("body"); v_MainNodeName = "GetItemTransactionsResponse"; x_MainNode =...

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

Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman -...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 "it's a poor workman who blames his tools". Let's make do with what we have. The 2 Acer monitors only have DVI and VGA inputs. The 3 Dell monitors can daisy chain with a combination of DisplayPorts and Mini-DisplayPort, which means that only 1...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 Defaults ; -------------------------------------------------------------------------------------- #NoEnv #Warn SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance force v_Company := "Joel Lipman .Com" v_CompanyKey := StrReplace( v_Company, " ",...

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

Zoho CRM: Change System Field Lengthhttps://joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 the "Number of Characters allowed" field and select "Inspect Element" Expand the DIV the field is in and double-click on the INPUT element (specifically the disabled="disabled" attribute), then press delete/backspace to remove the attribute. Also remove...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function: void...

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

Zoho Deluge: Convert Hex to RGBhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color...

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

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

23 June 2025 unzip vosk-model-small-en-us-0.15.zip Convert Your MP4 to MP3 (extract the audio from the video) ffmpeg -i input_video.mp4 -q:a 0 -map a output_audio.mp3 Convert Your MP3 to WAV (mono, 16KHz) ffmpeg -i output-audio.mp3 -ar 16000 -ac 1 -f wav...

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