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.

Size() formula query function

  • 1 minute(s) read
Prev Next

Size() is a formula query function you can use to count the number of records in a text, user, or record list. Size() can use GetRecords as a parameter, or it can use a user list or multi-select text field.

Size() examples

 

To query the same table

To query a different table

Result

Function layout

Size(GetRecords("{query}"))

Size([Mulit-Select Field Name])​

Size(GetRecords("{query}", Table Alias))

Size([Mulit-Select Field Name], Table Alias)

Numeric value

Example using a hard-coded value

Size(GetRecords("{6.EX.'In Progress'}"))​

Counts the number of records where field ID 6 is equal to "In Progress"

Size(GetRecords("{6.EX.'In Progress'}", [_DBID_PROJECTS]))​

Counts the number of records in the table assigned alias DBID_PROJECTS where field ID 6 is equal to "In Progress"

Example field titled: Total # of projects In-Progress. Example value returned: 3

Total count: 3

Example using a field reference

Size([Assignees])

Counts the number of assignees (list-user field)

Size([Assignees], [_DBID_PROJECTS])

Counts the number of assignees (list-user field) in the table assigned alias DBID_PROJECTS

Example field titled: Total # of employees assigned to project. Example field value: 4

Total count: 4

Size(GetRecords("{6.EX.'"&[Status]&"'}"))

Counts the number of records where field ID 6 is equal to the value found in the Status field of the record this formula is being calculated on

Size(GetRecords("{6.EX.'"&[Status]&"'}", [_DBID_PROJECTS]))​

Counts the number of records on the table assigned alias DBID_PROJECTS where field ID 6 is equal to the value found in the Status field of the record this formula is being calculated on

Example field titled: Total manager hours spent. Example field value: 7

Total count: 2