Zoho Templates - Font size is inexplicably tiny
This is an article resolving an issue where a template will shrink all the text when in PDF preview.
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 search477 entries / matching AI
Clear filters
Zoho Deluge - Update Creator from CRM
This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM.
Excel - Check a column for values found in another column
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.
MS Excel - Split Workbook into separate files per sheet
This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet.
Google Drive API v3 - OAuth2 using Service Account in PHP/JWT
This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using PHP/cURL... In that this one doesn't...
Zoho CRM: APIv2 using PHP & cURL
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to the system.
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...
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
Zoho Deluge: Loop through 30 Minute Slots
This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again.
Loading more notes...
No more notes to load.