GetRecords() formula query function – Quickbase Help

GetRecords() is a formula query function 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, SumValues, or Size 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