Get(UUIDNumber)
Returns a number representing a large Universally Unique Identifier (UUID) value.
Format
Get ( UUIDNumber )
Parameters
None
Data type returned
number
Originated in version
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.