Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help with detecting duplicates in a field

Topic Labels: Formulas
Solved
Jump to Solution
362 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

4 Replies 4

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!