Get(UUIDNumber)

Returns a number representing a large Universally Unique Identifier (UUID) value.

Format 

Parameters 

None

Data type returned 

number

Originated in 

FileMaker Pro Advanced 17.0

Description 

Returns a unique, 24-byte (192-bit) number. For example, you can use this function to generate a unique ID of a record. Using this function instead of Get(UUID) as the calculated value of a primary key field may improve the performance of operations based on relationships.

For unstored calculations, returns a new number each time Get(UUIDNumber) is evaluated.

Example 1 

Auto-enter calculation: In a number field, specify the auto-enter calculation Get(UUIDNumber). See Defining automatic data entry.

Every new record has a unique ID in the field—for example:

3351455178917488228606469712264530601969081773070792730006

or 3.3515e+57, if displayed in a field with data formatting set to General.

You can use this technique to define a primary key field.

Example 2 

Unstored calculation: In a calculation field, specify the calculation Get(UUIDNumber). For Storage Options, select Do not store calculation results. Every time a record is accessed, a new number is generated.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

Get(UUID) function

About formulas

About functions

Defining calculation fields

Using operators in formulas