GetRecords() formula query function

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

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