UNIQUEID()

Returns a newly-generated pseudo-unique ID (Text value).

Syntax

UNIQUEID([type])

• type - Optional. Type of pseudo-unique ID. Valid values are UUID and PackedUUID. 

UNIQUEID() (with no argument) generates a sequence of 8 random digits and letters suitable for use as a unique identifier within the app, such as a row key. The generated ID is not strictly unique. Instead, it is sufficiently random as to be effectively unique for all practical uses within the app. The chance of a duplicate ID being generated is virtually zero.

UNIQUEID("UUID") generates a version 4 universally-unique identifier (UUID), a sequence of random digits and letters suitable for use as a unique identifier. While the generated ID is not guaranteed to be unique, it is sufficiently random as to be effectively unique for all purposes.

UNIQUEID("PackedUUID") generates a sequence of 22 random digits, letters, hyphens, and underscores suitable for use as a unique identifier. While the generated ID is not guaranteed to be unique, it is sufficiently random as to be effectively unique for all purposes.

See also

RANDBETWEEN()