Articles

AutoHotkey: Get Media Information and Display

: Category: AutoHotkey; 07 August 2020; Hits: 29014

Applies To:

Microsoft Windows 7 Professional v6.1.7601 32-bit
AutoHotkey v1.1.33.02

What?
This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS.

Why?
I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general.

How?
So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds.

: Category: Windows OS; 30 July 2020; Hits: 41860

Applies To:

Microsoft Windows 10 Pro v10.0.18362

What?
This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice.

Why?
I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click...

How?
To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it:

: Category: Zoho; 14 July 2020; Hits: 37442

What?
So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page.

Why?
There might be different articles out there and discussion forums that do cover this but it takes me so long to find the solution with the right syntax.

How?
So I'm going to start with 1 method and then update this article with other methods.

: Category: AutoHotkey; 08 July 2020; Hits: 38188

Applies to:

Microsoft Windows 7 Professional - Service Pack 1
AutoHotkey v1.1.33.02

What?
So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name.

What I have

EDIT 0_00 0_30 My File 1 00_00 00_30.txt
edIT 0_00 0_31 My File 2 00_00 00_30.txt
eDIT 0_00 0_30 My File 3 00_00 00_31.wav
My File 3.wav
My File 3 - Copy.wav

What I want

My File 1.txt
My File 2.txt
My File 3 (2).wav
My File 3.wav
My File 3 (3).wav

How?
So if you copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files.

: Category: Articles; 05 July 2020; Hits: 21301

Ergonomic adjective
"relating to or designed for efficiency and comfort in the working environment."

So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like...

I made mine into a meme:

Working from Home - Back Breaking : Next Level

Working from Home - Back Breaking : Next Level

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books

: Category: Zoho; 15 May 2020; Hits: 76621

What?
This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books.

Why?
Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it.

How?
So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves certain bits out. Just getting the syntax right and using the . setParamName is key.

: Category: Zoho; 04 May 2020; Hits: 58942

What?
So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later.

Why?
I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps.

How?
We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it.

: Category: Zoho; 20 April 2020; Hits: 28883

What?
A very quick article on how to push a multi-select picklist from CRM to Creator.

Why?
We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value.

// What I have in CRM:
{"My_MultiPicklist":["Option1","Options 2, 3"]}

// What Creator understands: FAILS
{"My_MultiPicklist":["["Option1","Options 2, 3"]"]}

With workaround .toString()

// What Creator understands: FAILS
{"My_MultiPicklist":["Option1","Options 2"," 3"]}

How?
So the way to push this value over to Creator is by converting the list to a string... notably comma delimited:

Articles

Latest Articles

Accreditation

Donate & Support

RSS Feed

Joes Word Cloud