---
title: "Find field, record IDs, and table aliases"
slug: "find-field-record-ids-and-table-aliases"
updated: 2026-04-29T17:04:09Z
published: 2026-04-29T17:04:09Z
canonical: "help.quickbase.com/find-field-record-ids-and-table-aliases"
---

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

# Find field, record IDs, and table aliases

When you use a query in a formula query function, you may need to reference field and record IDs, and table aliases.

## Find field IDs

1. Open a table and select **Settings** from the table card in the page bar. ![Table card is second item in breadcrumb, directly after the home icon](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/34013162953748.png)
2. Select **Fields**. On the Fields setting screen, you can view Field Label, Type, Relationship, and Field ID.

## Find record IDs

The record ID field is automatically created for each table and the record ID# is always assigned to field ID 3.

- To find the record ID, search for field ID 3.
- By default, the record ID field name is Record ID#
- To see the record ID field when you view a record, add it to a form (see [Design a form](/v1/docs/designing-legacy-forms))
- To add the record ID field to a table report, see [Creating table reports](/v1/docs/creating-table-reports)

## Can't find the record ID?

Someone may have changed the default field name. Since the record ID is always field ID 3, you can locate which field is serving as the Record ID# by identifying the field with ID 3.

## Find a table alias

It's possible to search records from other tables using the table ID; however, it is best practice to use the table alias.

1. Open a table and select **Settings** from the table card in the page bar. ![Table card is second item in breadcrumb, directly after the home icon](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/34013162953748.png)
2. Select **Advanced settings**. The table alias appears in capital letters at the end of the **Advanced Table Settings** section.