I want to get the unique value of the {Photos IDs} column, but ARRAYUNIQUE() doesn’t work, presumably because it has a newline symbol in it. What should I do
Page 1 / 1
ARRAYUNIQUE() only works on arrays, such as in rollup fields. It does not work on lists that are really text strings. Your formula field is probably producing a text string. How are you generating the list initially? If there is a rollup earlier in the process, you can try putting ARRAYUNIQUE() there.
If the values come from a long text field, you can use a script to split the text string into a list and make the list unique.
ARRAYUNIQUE() only works on arrays, such as in rollup fields. It does not work on lists that are really text strings. Your formula field is probably producing a text string. How are you generating the list initially? If there is a rollup earlier in the process, you can try putting ARRAYUNIQUE() there.
If the values come from a long text field, you can use a script to split the text string into a list and make the list unique.
I can’t, because the value of the Photos IDs column is the ID of the attachment in the automatically captured attachment column
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.