---
title: "GetRecords() formula query function"
slug: "getrecords-formula-query-function"
updated: 2026-04-29T17:03:52Z
published: 2026-04-29T17:03:52Z
canonical: "help.quickbase.com/getrecords-formula-query-function"
---

> ## 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.

# GetRecords() formula query function

GetRecords() is a [formula query function](/v1/docs/what-are-formula-queries) that lets you dynamically search for records using a custom query.

- You can't use this function on its own. Results depend on the other function where it's used.
- Use it within the [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

## GetRecords() examples

|  | **To query the same table** | **To query a different table** | **Result** |
| --- | --- | --- | --- |
| Function layout | `GetRecords("{query}")` | `GetRecords("{query}", Table Alias)` | List of records |
| Example using hard-coded value | `GetRecords("{6.EX.'In Progress'}")` Returns a list of record IDs where the value of field ID 6 is equal to "In Progress" | `GetRecords("{6.EX.'In Progress'}", [_DBID_PROJECTS])`​​ Returns a list of records from the table with alias `DBID_PROJECTS` where the value of field ID 6 is equal to "In Progress" | Results depend on the other function where it's used |
| Example using field reference | `GetRecords("{6.EX.'"&[Manager name]&"'}")` Returns a list of record IDs where the value of field ID 6 is equal to whatever value populates the `Manager name` field of this record | `GetRecords("{6.EX.'"&[Manager name]&"'}",[_DBID_PROJECTS])` Returns a list of record IDs from the table with alias `DBID_PROJECTS` where the value of field ID 6 is equal to whatever value populates the `Manager name` field of this record | Results depend on the other function where it's used |