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

17 July 2014 "`n • " ThisManyWorkingDaysMessage "`n • " ThisManyWorkingHoursMessage "`n • " ThisManyWorkingMinutesMessage Message3:="Comments from the employee performance evaluation:" If ThisMessageIndex = 0 TrayTip, ByeBU, %Message0%,10,1 If ThisMessageIndex = 1...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 it, I would add the category parameter to restrict searches as I see from Google searches that this does not exist as yet. Comments/Questions Please use the comment box below to add any questions (you can even post anonymously) or suggestions you might...

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

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes)...

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

Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 Joe"; v_MyFormattedString = v_MyString.replaceAll("(\b\w+\b)(?=.*\b\1\b)",""); // yields World Hello Joe Remove block comments: v_MyRegEx = "(\/\*([^*]|(\*+[^*\/]))*\*+\/)"; v_MyString = "String to output: /* this is a comment */"; v_MyFormattedString =...

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

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

08 July 2020 A_LoopFileName, "." A_LoopFileExt, "") a_ThisFileName := StrSplit( v_ThisFileName, A_Space, ".") ; remove converter comments from file name v_NewName := "" Loop % a_ThisFileName.MaxIndex() { v_FoundUnderScore := InStr( a_ThisFileName[A_Index], "_") if(...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 the function against a paid invoice - check the fields updated. Go to Sales > Invoices > Select an invoice > Click on "Comments & History" Go into Settings > Automations > Workflow Logs > Custom Functions: check if/when they occurred and in relation to...

• 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 { l_ZB_InvoiceRecipients.add(m_ZB_Person.get("email")); } } } } // // email the invoice (using template and updating comments/history) - also marks as sent m_Params = Map(); // recipients is a list of emails unlike contact persons in invoice request...

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