Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Help with detecting duplicates in a field

Solved
Jump to Solution
1925 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Janene_Pappas
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve attempted to follow the recommendations here to detect duplicates in a field but have not been successful and could use some expert eyes on what I’ve implemented. I did put a reply on that thread but since it’s a couple of years old, figured I should start my own question. Here are 2 screenshots from the 2 tables in play. Anyone see where I went wrong? TIA!

Screen Shot 2022-03-28 at 12.40.20 PM
Screen Shot 2022-03-28 at 12.38.13 PM

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

values is a pure array, the formula you wrote needs to handle strings. So replace all instances of values with ARRAYJOIN(values)

See Solution in Thread

5 Replies 5
Kamille_Parks
16 - Uranus
16 - Uranus

values is a pure array, the formula you wrote needs to handle strings. So replace all instances of values with ARRAYJOIN(values)

Thanks for the reply @Kamille_Parks

I thought the field {All IDs} being an ARRAYJOIN already would then be put into the Number of IDs rollup as the long text result of the ARRAYJOIN?

You’re doing a rollup of a rollup. So you’re still dealing with an array of strings, even though every record is linked to just one record its still an array.

Thank you for the explanation and this worked great!

Tito_Alverio
6 - Interface Innovator
6 - Interface Innovator

I needed a similar setup and this worked for me. Having a rollup detect when an email is used multiple times as a way to track a duplicate person entry.