Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search341 entries / matching Data
Clear filters
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...
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...
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.
Thought I'd write an article to help me the next time I needed to connect the Unleashed inventory software API directly to Zoho Analytics and pull in the product catalogue.
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...
Pretty self-explanatory really. Something to be cautious about but it took me so long to do that I needed an article here to help me if ever I get asked to do it again. Siimply put, Zoho Analytics can't see the Zoho People Salary table within the built-in integration / synchronization.
A quick article on how to get Zoho CRM to update the deal or opportunity type field with "New Business" or "Existing Business" depending on whether this won opportunity is the second time for this account.
This is an article to document how to configure Zoho People and Zoho Analytics so that reporting teams can access analytics data restricted by region. It explains how to separate global HR access from regional reporting access, how to prevent users from viewing employee or payroll data outside their area of responsibil...
A short article explaining how Zoho Deluge allows a variable assignment to be written across multiple lines, as long as the statement ends with a semi-colon. This has a limited number of use cases, but is useful to be aware of if you have not come across it before.
Working principle
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.
Recently Added
Zoho Books: Change a Purchase Order's Delivery Address over API Zoho CRM: Presenting ABM for Zoho CRM: Expand and retain your customers with precision Zoho CRM: Announcing the new SKILL.md for Zoho CRM and the updated OAS repository! Zoho CRM: Allow Only Administrators To Change Task Owners Zoho Billing: Workflow does not exist!Protected notes
Log in for protected notes and any private client projects assigned to your account.