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

608 entries

Zoho Deluge: Proper Case for Names
Zoho Deluge

Zoho Deluge: Proper Case for Names

This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions.

Read note 30,118 hits
Zoho Creator: Find Duplicates by Customer Name for Large Datasets
Zoho Creator

Zoho Creator: Find Duplicates by Customer Name for Large Datasets

There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit.

Read note 30,846 hits
Zoho Deluge: Determine if Daylight Savings are in effect
Zoho Deluge

Zoho Deluge: Determine if Daylight Savings are in effect

If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works.

Read note 26,493 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
810 Site articles
29.7m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.