@Unique (Formula Language)
Without a parameter, returns a random, unique text value. With a parameter, removes duplicate values from a text list by returning only the first occurrence of each member of the list.
Syntax
@Unique @Unique( textlist )
Parameters
textlist
Text list. Any text list.
Return value
Without a parameter:
uniqueValue
Text. A random, unique text value.
With a parameter:
uniqueList
Text list. The text list, with duplicate values removed.
Usage
@Unique is case-sensitive.
Examples
- This example returns red; green; blue.
@Unique("red":"green":"blue":"green":"red") - This example returns red; green; blue; Green.
@Unique("red":"green":"blue":"Green":"red")