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
+9
+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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.