How can I delete a duplicate entry automatically?

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:

Then create a formula that counts the number of tasks (or whatever) with the same name:

image

When looking at a view of the entities

adding a filter will make it easy to see the duplicates:

I think adding a duplicate check on CSV import would be a nicer solution, but until that’s available, this was the best I could come up with :thinking:

2 Likes