Syntax

Basic Form

UNIQUEID()

UUID Form

UNIQUEID("UUID")

Description

Basic Form

UNIQUEID() with no arguments generates a sequence of eight 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: just 1 in over 28 trillion.

UUID Form

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

Return Value

A Text value: a newly-generated pseudo-unique ID.

See Also

RANDBETWEEN()

Did this answer your question?