---
title: "GetRecord() formula query function"
slug: "getrecord-formula-query-function"
updated: 2026-04-29T17:03:42Z
published: 2026-04-29T17:03:42Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.quickbase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# GetRecord() formula query function

GetRecord() is a [formula query function](/v1/docs/what-are-formula-queries) you can use to fetch a specific record for reference.

- You can't use this function on its own
- Use within [GetFieldValues](/v1/docs/getfieldvalues-formula-query-function), [SumValues](/v1/docs/sumvalues-formula-query-function), or [Size](/v1/docs/size-formula-query-function)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 | `GetRecord(Numeric field)` | `GetRecord(Numeric field, Table Alias)` | Returns the record with the specified record ID |
| Example using hard-coded value | `GetRecord(101)` Returns the record with record ID 101 | `GetRecord(101, [_DBID_PROJECTS])​​ ` Returns the record with record ID 101 on the table assigned alias `DBID_PROJECTS` | N/A Results depend on the other function where it's used |
| Example using field reference | `GetRecord([Primary Contact ID#]) ` Returns the record with the record ID that matches the value in `Primary Contact ID#` in the record where it's used | `GetRecord([Primary Contact ID#], [_DBID_CUSTOMERS])` Returns the record with the record ID that matches the value in `Primary Contact ID#` in the record where it's used. In this case, the record is on the table with alias `DBID_CUSTOMERS` | N/A Results depend on the other function where it's used |