RECORDID

Generates IDs for each row in a table

RECORDID(Starting Value)

Generates a unique id, incrementing sequentially, for each row in a given table.

Arguments

Argument	Description
Starting Value	The value to hold as the first id, with each after it increasing sequentially.
Data Type	Data type to return: string or number.
Leading String	Optional. Enables a specified string to lead all record ids.
Size	Optional. Determines length of ID to return; must be a number.

Output

A column of unique ids.

Example 1

Example 2