Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 20k+ contact records and that's only half of the 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...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 = v_MyFormattedString.replaceAll("[^a-z0-9@\-.]+",""); // yields somewhere@beyondthesea1.com Replace any duplicates: v_MyString = "Hello World Hello Joe"; v_MyFormattedString = v_MyString.replaceAll("(\b\w+\b)(?=.*\b\1\b)",""); // yields World Hello Joe...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 The aim here is to have a scheduled task that on the 1st of every month, takes the invoices for the month before, and duplicates each one for the new month. How? First you have to get all the applicable fields from the settings API. In API v2, you have...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file as is. ; ;...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 { if(!isnull(r_Check.get("id"))) { v_CountExists = v_CountExists + 1; break; } } } if(v_CountExists == 0) { // // prevent duplicates by updating record with existing name if exists v_Name = v_CandidateZohoID + "" + r_Data.get("id"); // // retrieve...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 The document form contains the fields: Ticket (lookup to Ticket form), Image, File, Local Image, Subform Row ID (prevents duplicates). Note: I create the form then add it as a subform on the parent form first, then add the lookup to the ticket field on...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 Hopefully this will be of some use to you. Unduplicater v1.1 is a basic tool to compare two folders and remove duplicates (ignoring file extensions). For more information on this one, see the DOWNLOAD section of this website.

• Type: Article
• Author: Joel Lipman
• Category: Products
• Language: *

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the other entry does not... This...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *