+3I’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!
Best answer by Kamille_Parks11
values is a pure array, the formula you wrote needs to handle strings. So replace all instances of values with ARRAYJOIN(values)
+27values is a pure array, the formula you wrote needs to handle strings. So replace all instances of values with ARRAYJOIN(values)
+3values 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?
+27Thanks 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.
+3You’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!
+9I 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.