JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

Advanced search

608 entries

AutoHotkey: Check Windows Folder Sizes
AutoHotkey

AutoHotkey: Check Windows Folder Sizes

So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained withi...

Read note 32,925 hits
Calculate Aspect Ratio
Graphic Design

Calculate Aspect Ratio

So this is a quick article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new height (original width / original height) x new height = new width

Read note 23,181 hits
Zoho Deluge: Check Time Booking Slots
Zoho Deluge

Zoho Deluge: Check Time Booking Slots

Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How?

Read note 13,122 hits
Zoho Deluge - MD5 function
Zoho Deluge

Zoho Deluge - MD5 function

So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task.

Read note 24,234 hits
Zoho Inventory Template Issue: First Page is Blank
Zoho Inventory

Zoho Inventory Template Issue: First Page is Blank

So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How?

Read note 20,263 hits
Zoho Deluge - Hide Reset Button on Form
Zoho Deluge

Zoho Deluge - Hide Reset Button on Form

So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes:

Read note 17,074 hits
Display a thumbnail of a Google Drive video
Google

Display a thumbnail of a Google Drive video

A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google...

Read note 26,145 hits
Zoho Deluge - Get English Ordinal
Zoho Deluge

Zoho Deluge - Get English Ordinal

This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018".

Read note 26,816 hits

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
810 Site articles
29.8m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.