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
How do I use the ARRAYUNIQUE() for this two-line string
+9This topic has been closed for replies.
+29ARRAYUNIQUE() 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.
+9ARRAYUNIQUE() 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.