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

344 entries / matching Data

Clear filters
Zoho MCP in 2026: What Claude Can Actually Do Inside Zoho CRM
Zoho CRM

Zoho MCP in 2026: What Claude Can Actually Do Inside Zoho CRM

Zoho's MCP (Model Context Protocol) server lets AI assistants such as Claude connect directly to Zoho CRM and work with your live data through natural language. Rather than you clicking through views and filters, the AI can read your pipeline, summarise deal status, flag stale records, bulk-update f

Read note 104 hits
Zoho Books: Change a Purchase Order's Delivery Address over API
Zoho Books

Zoho Books: Change a Purchase Order's Delivery Address over API

A note on changing a Zoho Books purchase order's delivery address while creating supplier orders from an accepted Zoho CRM Quote. My original method created an organisation address in Books and assigned its ID to a purchase order. This updated version adds a delivery address to the customer instead, then uses that cust...

Read note 195 hits
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 265 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 278 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 6,208 hits
Zoho Books: getRecordsByID
Zoho Books

Zoho Books: getRecordsByID

Not sure what this is but it's an article listing some errors in Zoho Books when using the shortcode command to retrieve the details for an item in Zoho Books...

Read note 3,728 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
819 Site articles
30.1m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.