Find Duplicate Rows

So with no one any idea what may be causing this issue…

I need a way for the App to detect duplicate rows - simply where data in 5 to 6 columns match. Easy to do as a virtual column. But this App is already dog slow. A virtual column which compares 4000 rows against the other 3999 rows isn’t going to help :confused: So can anyone suggest a way I can have a Report run at 23:59 each night, calling an action to run on each row, with a formula to check if the 5-6 columns on this row matches any other rows?

What exactly do you need a suggestion on? How to write the formula? I imagine it’d just be a bunch of IN()s inside of an AND(). What should happen when a duplicate is detected? Send a message? Delete the record?

Why don’t you just detect duplicates when a record is initially created?

1 Like

Hi @Marc_Dillon

I ok with the formula, its more a question of how to do it using Reports, Workflows and Actions

"Why don’t you just detect duplicates when a record is initially created?"
The whole reason I need to do this is because users are creating duplicates. There is a formula in the linked post that should stop this from happening. Yet it isn’t always doing that. I’ve tested it multiple ways and cannnot create a duplicate. My best guess at the moment is the following:

1 = They are on a mobile phone with a poor internet connection
2 = They create a record
3 = They look at a slice of records they have created and don’t see this new record
4 = They create an identical record (sometimes less than 30secs after creating the first one)
5 = The current formula to ban duplicates does not function because it relies on data in a slice or large table and somehow doesn’t ‘see’ the first record

I’ve seen evidence of this happending now 3 time and from 2 seperate users. If I go into any of these records and edit them the App instantly errors saying they are a duplicate can cannot be saved.

Hence the requirement for a double-check on a daily basis

Maybe I’ll have to do it using a sheets formula…

Or put in another rule that says you can’t add another record until 5min or so has elasped

But I’m a bit freaked out by how this can happen :confused:

I still don’t know what you want to do.

Then write something in a column if this row is a duplicate of another

1 Like

Thanks @Marc_Dillon . Sorry didn’t see “Change Data” button before :weary: