Finding Airtable IDs
  • 13 Jan 2023
  • 2 Minutes to read
  • Dark
    Light

Finding Airtable IDs

  • Dark
    Light

Article Summary

Learning how to find the Base, Table, View, and Record IDs related to your Airtable bases can help you troubleshoot issues, use our API effectively, prefill forms, and more.


Base URL IDs

Base 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 this (Google Chrome):

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"

Your browser does not support Svg.click here to download

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.


Expanded record URL IDs

Expanded record URLs

If you expand a record, then you can also see the specific Record ID appear in your browser's address bar. Record ID strings always begin with "rec":

Your browser does not support Svg.click here to download

You can also determine Record IDs by setting up a formula. In practical use, record IDs can be a great tool to use with our Automations feature.


Finding Workspace IDs

If you need to find your workspace ID, you can do so by opening the workspace settings for any of your workspaces. You can open your workspace settings from your account page or from the Airtable home screen.

Open your workspace settings

Open from your account page

Navigate to https://airtable.com/account and you'll see a list of any workspaces in the left-hand sidebar. Select a workspace to open its settings.
360101310414workspaces1.png

Open from the home screen

Start by clicking the arrow to the right of any workspace name. This will open a menu

1500002423842opensettings1.png

Copy the workspace ID from the address bar

Get workspace ID

As soon as you open the workspace settings, the URL in your browser's address bar will update and look something like the following: https://airtable.com/wspBHSbFDdQCkyKtJ/workspace/billing. The text string starting with wsp is your workspace ID.

1500002424082wspid1.png


Finding IDs in 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?