One common headache, especially in CRM databases, is finding duplicates. While Notion doesn’t have a built-in feature for this, there’s a quick workaround:

1. Create a new database called “Duplicate Checker” and add one item named “Duplicate Checker.”
2. Set up a two-way relation property between this new database and your main database, calling the properties “Duplicate Checker” and “Items.”
3. Link all items in your main database to the “Duplicate Checker” item.
4. In your main database, add a formula property titled “Duplicates” and paste in the following formula:

‍

prop("Name") ?
prop("Duplicate Checker").map(current.prop("Items")).replaceAll(" ", "")
.replaceAll("\\b" + replaceAll(prop("Name"), "[ |,]", "") + "\\b", "*")
.replaceAll("[^*]", "")
.length() > 1
: false

‍


This will highlight any duplicate items.

Huge thanks to Sev Estil for the formula! You can download his template here if you want a ready-made setup.