JOEL LIPMAN

Knowledge base / Since 1999

Advanced
search

Practical notes on CRM development, automation, APIs and everyday IT.

Browse all notes

202 results

  1. Zoho Creator

    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 ...

  2. Transact-SQL

    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 ...

  3. MySQL

    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 ...

  4. Joomla

    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- ...

  5. Excel

    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.. ...

  6. MySQL

    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 ...

  1. Zoho Desk

    Zoho Desk: Interim round-robin ticket assignment using Deluge

    ... ad - 1; } m_AgentCounts.put(v_AgentID,v_Workload); } } } } // // Find the lowest workload and retain every tied agent v_LowestCount = -1; l_LowestAgentIDs = List(); if(v_CanContinue) { for each v_AgentID in l_AgentIDs { if(!m_AgentCounts.co ...

  2. Zoho

    OpenAI ChatGPT + Zoho CRM: Fix the MCP Connection Error

    ... creenshot below shows this selection of read tools: PurposeTools Find and read records getRecords, getRecord, searchRecords, executeCOQLQuery Inspect CRM structure getModules, getModuleByApiName, getFields Count records getRecordCount Read ...

  3. Zoho CRM

    👍 Zoho CRM's Notes now gets Reactions and a new look

    ... identify other reactors through the announced controls and still find the note’s existing actions. Anything the demo cannot establish—including notifications, deactivated-user behaviour and rollout outside the listed regions—remains an open ...

  4. Zoho CRM

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

    ... perform the related record updates required here. This function finds the linked Sales Orders and Quotes, then the Purchase Orders linked to those records. It builds distinct lists of record IDs before making the updates, so a record found ...

  5. Zoho CRM

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

    ... The receiver uses an email subject and a supplied Contact ID to find a transaction and copy eligible received emails from that Contact's email history. The receiver also attempts to copy CRM inline images referenced by img_id:. It download ...

  6. Zoho CRM

    Zoho CRM's WhatsApp integration now supports multiple accounts, multiple numbers, and custom modules

    ... g integration, go to Setup → Customization → Modules and Fields. Find Messages, open its more-options menu, and select Update Messages Modules. Add the required modules and save. Choose the record types your staff actually work with. In our ...

Knowledge base

Search notes

Find matching words in article titles and content.