JOEL LIPMAN

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

90 entries / matching JSON

Clear filters
Zoho Desk: Interim round-robin ticket assignment using Deluge
Zoho Desk

Zoho Desk: Interim round-robin ticket assignment using Deluge

This is a quick article to document an interim replacement for Zoho Desk’s built-in round-robin ticket assignment using a custom Deluge function. When a ticket is created, the function assigns it to an eligible agent with the fewest outstanding tickets in the same department. It excludes specified email addresses using...

Read note 133 hits
Zoho CRM: Sync Deal and related record owners from Zoho Desk
Zoho CRM

Zoho CRM: Sync Deal and related record owners from Zoho Desk

This is a quick article to document a Zoho CRM standalone function that sets the owner of a Deal and its related Sales Orders, Quotes and Purchase Orders to the CRM user matching the current assignee of a linked Zoho Desk ticket. The function takes a Deal record ID. It retrieves the ticket ID stored on that Deal, reads...

Read note 161 hits
Zoho CRM: Link supplier emails to the Purchase Order Emails related list
Zoho CRM

Zoho CRM: Link supplier emails to the Purchase Order Emails related list

The aim is to make supplier correspondence appear in the Emails related list of the correct Purchase Order in Zoho CRM. When a supplier replies about an order, the email should be available to the team reviewing that Purchase Order. The same approach can include emails you send to the supplier. This guide uses a PO ref...

Read note 440 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 335 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 337 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,319 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,899 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
825 Site articles
30.2m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.