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

17 July 2014 Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 What? Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux system, you will know of a feature where you can have another virtual desktop on your device. For those that...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 is key. Let's make it even more interesting: I'm going to use a subform with the file upload field type so our record can have more than 1 file attached to it. the CRM.attachFile command Okay as a first example, there is a problem here, you asked for...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some clients have referred to this as the "spinning circle of death": they...

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

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

12 March 2022 cable connections I need to practice what I preach: "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...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 ZohoCRM here despite storing the record in ZohoCreator as the app and data processing is mostly done in ZohoCreator. I could have setup webhooks to go directly to Zoho Creator but I don't find Zoho Creator reliable when receiving and responding to...

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

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 new products, special offers or other information which we think you may find interesting using the email address which you have provided. From time to time, we may also use your information to contact you for market research purposes. We may contact...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to explain...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 your e-mail" to something else I will explain how in this guide. I cannot be 100% sure this guide will work for people who have certain extensions installed or who have SEO turned on as i have not tried it. Step One: First if you don't already have a...

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

Setting up your store to use SSLhttp://mail.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 and shared secure domain which may be used by other customers of your hosting company. Dedicated SSL means that you will have your own SSL certificate which enable you to run your store on one domain using http and https. e.g. Shared SSL: Master Domain:...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had never used phpBB3 before nor were the instructions for applying the template and...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttp://mail.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the server, configure the web application to use the newly uploaded report, export to a Crystal Report,...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun"...

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

Generate a Timesheet in MySQL http://mail.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4 H107C This model is the DJI Phantom FC40 so...

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

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

09 March 2015 This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that...

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

Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token, once we have a Refresh token we will generate an Access token. Pre-amble Quit trying to generate an authtoken v1 (CRM Deprecation Sunset...

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

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

10 December 2020 This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 Took us a while to find this and perhaps others would have a quicker way but here's the instructions on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and...

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

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...

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