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

Last updated