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

477 entries / matching AI

Clear filters
Zoho Billing: Workflow does not exist!
Zoho Books

Zoho Billing: Workflow does not exist!

This is an article about a Zoho Billing custom function that worked when it was executed manually but did not run automatically when a new invoice was created. The custom function was configured with the Invoice Created trigger. However, opening the function displayed the following message: Workflow does not exist! Inv...

Read note 224 hits
Zoho Deluge - Calculate Portion Count
Zoho Deluge

Zoho Deluge - Calculate Portion Count

A function to calculate how many trays of each available size are needed for a requested number of portions. Pass in the portion count and a list of tray capacities, and Ascent.fn_CalculatePortionCount returns a map of tray sizes to quantities. The important detail is what “best” means: first minimise surplus capacity...

Read note 219 hits
OpenAI GPT Image 2.5: This house does not exist
Automation

OpenAI GPT Image 2.5: This house does not exist

A quick article on something a little different from my usual CRM functions and debugging notes. This time I have been playing with OpenAI's ChatGPT Image 2.5 and its sketch feature, using a few very rough drawings as the starting point for a Georgian-inspired home concept. The idea was to see how far I could take some...

Read note 304 hits
Zoho CRM: Add and Update Products from Zoho Analytics Discrepancies
Zoho Analytics

Zoho CRM: Add and Update Products from Zoho Analytics Discrepancies

A quick article on using a Zoho Analytics discrepancy table to add missing products and update existing product records in Zoho CRM. In this example, Unleashed supplies the product details, Zoho Analytics identifies the differences, and a scheduled Deluge function applies the changes to a custom CRM module.

Read note 5,276 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
816 Site articles
30.0m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.