GetRecord() is a formula query function you can use to fetch a specific record for reference.
- You can't use this function on its own
- Use within
GetFieldValues
,SumValues
, orSize
functions, which use a list of records as a parameter - Only generated record IDs (not custom key fields) can be used to fetch records using
GetRecord()
GetRecord() examples
To query the same table | To query a different table | Result | |
---|---|---|---|
Function layout |
|
|
Returns the record with the specified record ID |
Example using hard-coded value |
Returns the record with record ID 101 |
Returns the record with record ID 101 on the table assigned alias |
N/A Results depend on the other function where it's used |
Example using field reference |
Returns the record with the record ID that matches the value in |
Returns the record with the record ID that matches the value in |
N/A Results depend on the other function where it's used |