Flagging duplicate record

Topic Labels: Automations
473 6
Showing results for 
Search instead for 
Did you mean: 


Is there a formal that I can enter in the “Color” “Conditions” to mark when there is a duplicate Name?

Or is there some other way I can flag duplicate records?
Screen Shot 2022-05-31 at 3.44.08 PM|601x251

6 Replies 6

Hi @Katie_O_Connell
You would not be able to enter a formula in the field in your screen shot, it is just looking for a string to match.

Have you taken a look at the DeDupe application? It is free and will show you all duplicates and give you options to delete or merge.

There are some other steps you can take if the DeDupe app is not sufficient, feel free to let me know here and I can guide you to another path.

@Vivid-Squid, are you aware of an automated way of doing this (without using other apps such as Zapier, etc.)?

That all depends on your data and what you have to work with. Simply matching names is not a good solution and will not catch everything.

Do you have a unique identifier like an email address?

Hi @Katie_O_Connell
I know of three ways of finding duplicates.

  1. Use the DeDupe App
  2. Use a script like this one.
  3. Build in the original Deduplication 3.0 by @W_Vann_Hall into your base. It’s a bit of work, but has an example base, support documentation and video to guide along the way.

Method 3 is the only way I know that you then can use color by field or conditions like you showed.
I’ve used it in the waaaay past in my total n00b days, before the Dedupe App, and it works. A lot of work and fields to get there though, but it givs live ‘commentary’ in your base without you running a script or app.

Might not be the way for you, but it’s a way.