To return a record of a table by a given ID

With this function, you can return a specific record by the table name and the unique record ID. The returned value is referential, not the actual record itself (see disclaimer in "Return" section).

Syntax

record(table, number)

Return

rid

❗ The function will always return an "rid" type value, even if a record of the given numerical ID does not exist in the system. The check whether the record exists, the syntax record(table, number)._id can be used which returns the record ID for existing records only.

Examples

record(Customers, 540)

Result: The record with ID 540 will be returned from the Customers table.

record(Customers, 540).Date

Result: 03/16/2023

The field content Date of the record with ID 540 from the Customers table is returned.

See also

duplicate which creates a duplicate of a given record.

Create and delete records