Contents x
    Finding Airtable IDs
    • 13 Dec 2024
    • 5 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Finding Airtable IDs

    • Updated on 13 Dec 2024
    • 5 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Plan availability

    All plan types/levels

    Platform(s)

    Web/Browser, Mac app, and Windows app (Add mobile apps if relevant)

    Airtable terminology

    • Record ID - A record ID is a record's unique identifier that can be shared with collaborators and used within other Airtable features.

    • Record - A record is an individual item in a table. Records are the basic unit of data that are pulled into various views and interfaces.

    In Airtable, there are many IDs that can be helpful to know when looking to share information, automate processes, troubleshoot issues, and more. The article below covers instructions on how to determine the various Airtable IDs that you will come across in the product.

    Finding record IDs

    You can either determine a record’s ID by setting up a formula field or by expanding a record and gleaning the ID from the URL in your browser. Choose your method below. Record ID strings always begin with the string rec.

    To create a formula field to display record IDs:

    1. Open your Airtable homepage.

    2. Search for and open your preferred base.

    3. Click the + icon to the right of your desired table.

    4. Select the Formula field type and enter RECORD_ID().

    5. Click Create field.

    To locate a record ID via an expanded record’s URL:

    1. Open your Airtable homepage.

    2. Search for and open your preferred base.

    3. Select the table containing the preferred record and expand the record.

    4. Review your address bar for an address similar to airtable.com/appxxxxxxxxx/tblxxxxxxxxx/viwxxxxxxxx/recxxxxxxxx.  

      1. Your record ID is the recxxxxxxxx section of the address.

    Finding expanded record URL IDs

    If you expand a record, you can determine the specific record’s URL in your browser's address bar. This URL can be shared with other users who have base access so that they can navigate to the link and have the appropriate context of the record appear.

    Similar functionality can be accomplished in interfaces with record detail pages configured. That process is covered in another section below.

    Finding field IDs

    You can determine multiple field IDs at once or just a single field ID. Check out the options below to learn more.

    To find a single field’s ID from a field’s URL:

    1. Open your Airtable homepage.

    2. Search for and open your preferred base, table, and field.

    3. Click the drop down icon next to the name of the field ⌄.

    4. Choose the Copy field URL option from the menu.

    5. At this point you can either:

      1. Paste the URL in a message to another user with base access. On their end, when they open the URL, the field will be highlighted in a light blue color so that they can easily determine the field context that you want to share.

      2. Or you can paste the URL in your browser’s address bar and determine the individual field’s ID

    To find multiple field IDs:

    1. Open your Airtable homepage.

    2. Search for and open your preferred base and table.

    3. Click the “Manage fields” option under the “Tools” menu. Find more information here if you haven’t access Field manager before.

      1. Here, you’ll see a list of the the fields and a column for the “Field ID.” If you do not see the “Field ID” column, then click on the column visibility toggle to show the “Field ID” column:

    Finding base, table, and view IDs from URLs

    When you have a base open in a compatible web browser, you should see a URL in the address bar that looks similar to the example below:

    addressBarAirtableURL

    In between each backslash, you will find a string that identifies the base, table, and view IDs.

    • Base IDs begin with "app"

    • Table IDs begin with "tbl"

    • View IDs begin with "viw"

    If you were to click on another table or another view within this same base, then the URL would update to match the ID of the table or view that you are now looking at.

    Finding interface URL IDs

    To find an interface URL ID:

    From an open interface you will find two elements that make up the end of the URL:

    1. Base ID - Denoted by the prefix app as noted above

    2. Interface page ID - Indicated by the prefix pag

    If you are a user with editor permissions, then you can additionally add /edit to the end of the URL to open the interface page in edit mode.

    Finding Workspace IDs

    To find a workspace ID:

    1. Open your Airtable homepage.

    2. Search for and open your preferred base.

    3. Select your preferred workspace from the "All workspaces" menu.

    4. Once your workspace is open, the URL in your browser's address bar will display your workspace ID:

      1. https://airtable.com/workspaces/wspsqMNxxxxxxxxxxxxx?. The text string starting with wsp is your workspace ID.

    Note

    If your address bar ends with a "?", do not include this question mark character in the workspace's ID.

    Finding IDs in the admin panel

    This information only applies to customers who have access to admin panel on Business or Enterprise Scale plans. Additionally, org unit IDs are only available for customers using Enterprise Hub.

    Note

    It’s worth noting that Enterprise Scale and Business plan customers can access many other IDs from the admin panel as well. Consult the following admin panel pages to find additional IDs:

    Account ID

    To find your account ID:

    1. Navigate to your admin panel. A reminder that you will need admin permissions to access this page.

    2. Below the Settings page, you will see the “Account ID” information for your organization’s account.

    Org unit ID

    To find an org unit ID:

    1. Your organization will need to be using Enterprise Hub. Additionally, you will need super admin privileges to access admin panel at the top organization level.

    2. Navigate to your admin panel.

    3. Click the Organization tab if it isn’t already open. Under the “Organizational unit” column, you’ll see a list of each org unit belonging to your Enterprise organization. Below each unit’s name you’ll find its ID.

    Finding IDs in the Airtable API

    Base IDs

    To find a Base ID in the Airtable API, click on the help button near the top-right of your screen. This will open a menu where you will see the "<> API documentation" option.

    APIDocumentation

    After clicking the button, you will be brought to our API documentation page that will dynamically surface which base you are working in currently. Both the base name and Base ID will appear.

    baseIDInAPIDocumentation

    Field IDs

    In our Web API documentation, there is a section called Get base schema where you will find more information about how to identify Field IDs programatically from a specific table. It's worth noting that field IDs can also be gathered manually from the field manager. With the corresponding table open, click Manage fields in the upper right corner. This will open a window where you can find the appropriate field by name and then match that to the ID under Field ID.


    Was this article helpful?
    What's Next