UNIQUEID()

Pseudo-unique ID

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()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
13532469698436116557
true
Search Help Center
true
true
true
false
false