Mar 28, 2022 01:16 PM
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!
Solved! Go to Solution.
Mar 28, 2022 02:35 PM
values
is a pure array, the formula you wrote needs to handle strings. So replace all instances of values
with ARRAYJOIN(values)
Mar 28, 2022 02:35 PM
values
is a pure array, the formula you wrote needs to handle strings. So replace all instances of values
with ARRAYJOIN(values)
Mar 29, 2022 11:40 AM
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
?
Mar 29, 2022 04:06 PM
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.
Mar 30, 2022 08:02 AM
Thank you for the explanation and this worked great!
Sep 20, 2024 04:19 PM
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.