Hey everyone, nice to be a part of the fib fam :slight_smile: So, we import lots of data through CSV, and sometimes there might be duplicates from different files that get imported into the same type. Is there a way that I can set up an automation which checks for duplicate name fields and then de…

It’s actually quite difficult to do automatically, but there is a workaround way of highlighting duplicates: Create a many-to-many auto-relation to the type itself, where the criteria for a match is Name = Name: e.g. for the Task type: [image] Then create a formula that counts the number of tas…

hey there, and glad to have you in the fib fam :wink: When you have duplicates, does it matter which one gets deleted? Is it enough to assume that they are duplicates if the name is the same? Does the name have to match exactly, or does name=Name=NAME for example?

I think for this specific issue at hand : it doesn’t matter which one gets deleted Yes, lets just say the names can be used to identify the duplicates Name has to match exactly I think the best thing would be if while importing fibery told me which ones are duplicate and then I could choose what …

That’s some great logic work there @Chr1sG :slight_smile: thanks for this, I think this could work for the time being :slight_smile: There’s still one problem though, that filter is going to list all the duplicates including one original copy that I would like to leave behind. So I guess I would st…

Well, here’s another neat little trick that will allow you to select only one of the duplicate items: Create a formula field as follows: [image] This will be true for all but the oldest of the duplicates: [image] You can now filter on this flag and all but one of the entities in each group of …

Related: Check this post for (among other things) a script that does entity de-duplication using the GraphQL API: [image] Centralized script management for Workspace Ideas & Features 100% agree! A lot of my requests here are directly related to this. Here are some things …

How can I delete a duplicate entry automatically?

Get Help

Matt_Blais July 6, 2022, 3:55pm 7

Related: Check this post for (among other things) a script that does entity de-duplication using the GraphQL API:

Topic		Replies	Views
Form Improvement: Duplicate Check Ideas & Features	8	600	May 8, 2025
New template - Deduplication 👯‍♂️ News & Announcements	4	712	September 19, 2022
Script Request: Mark duplicates in relational DB Get Help	6	349	August 18, 2022
Import CSV and Update Existing Entities (where matches exist) Get Help	5	102	August 14, 2025
[✔️ DONE] Duplicate a record Ideas & Features	14	2544	November 22, 2022

How can I delete a duplicate entry automatically?

Related topics