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. If this record doesn't exist, null will be returned.

Syntax

record(table, number)

Return

nid

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