Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes195 results
Zoho Creator: Find Duplicates by Customer Name for Large Datasets
... he production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. How? My team of developers actually helped me solve this o ...
CharIndex Reverse - find occurrence starting from end of string in TSQL
What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column posit ...
MySQL: Find records in one table that are not in another.
The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going ...
Joomla: Unable to find install package
... ed with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and double- ...
Excel: Find values in one column that are not in another
What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new.. ...
MySQL: Find all non-alphanumeric rows
What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanu ...
Zoho Books: Change a Purchase Order's Delivery Address over API
... ated once that supplier's orders have been created successfully. Find the Books customer, or import the CRM Account or Contact immediately. The delivery address must belong to a Books customer. My function prefers the Quote's Account when o ...
Zoho CRM: Presenting ABM for Zoho CRM: Expand and retain your customers with precision
... omers who may need another product, and customers who need help. Find the right people at each company. Check who uses your product and who decides what the company buys. Keep their contact details linked to the company record. Send a helpf ...
Zoho CRM: Announcing the new SKILL.md for Zoho CRM and the updated OAS repository!
... response examples. This makes the relevant information easier to find. What? Zoho has released new resources to help AI coding assistants build solutions for Zoho CRM. These cover tasks such as retrieving records, automating work and creati ...
Zoho CRM: Allow Only Administrators To Change Task Owners
... cannot be changed on Standard. Under Module Permissions → Tools, find Change Owner and open its module list. Untick Tasks. Leave the main Change Owner switch on if users still need this permission for other modules. Zoho saves profile permi ...
Zoho Deluge - Calculate Portion Count
... search. The search can still allocate more large trays: here it finds another nine, producing 50 size-20 trays overall. The argument also applies when the best capacity exceeds the request: that solution still has to use the fewest trays f ...
Zoho Books: getRecordsByID
... "elephants","zbooks"); // yields {"code":5,"message":"We couldnt find any resource for the given ID. Please verify the ID and try again."} info zoho.books.getRecordsByID("items","12345678901","123456000000987654","elephants"); // yields Exc ...