@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

  1. This example returns red; green; blue.
    @Unique("red":"green":"blue":"green":"red")
  2. This example returns red; green; blue; Green.
    @Unique("red":"green":"blue":"Green":"red")