Finding Airtable IDs
  • 27 Aug 2024
  • 3 Minutos para leer
  • Oscuro
    Ligero
  • PDF

Finding Airtable IDs

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
Resumen del artículo

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.

Creating record ID fields

To create a field to display record IDs:

  1. Visit your Airtable homepage.

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

Finding record IDs

To locate a record ID:

  1. Visit your Airtable homepage.

  2. Open your desired base.

  3. Select and expand a 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

Expanded record URLs

If you expand a record, you can also see the specific record ID appear in your browser's address bar. Record ID strings always begin with "rec.” You can also determine record IDs by using a formula. In practical use, record IDs can be a great tool to use with our Automations feature.

Finding field IDs

Field IDs

  1. Navigate to the base and table containing the field you want to identify.

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

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

Interface URLs

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

Finding workspace IDs from a browser

  1. Log into your account and visit your home screen here.

  2. You will see a list of workspaces you own or have access to in the left sidebar. Select a workspace. If you do not see this sidebar, then click the sidebar toggle at the top left corner of the screen:

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

    Note

    If your address bar includes a “?” question mark at the end, do not include this question mark character in the ID of the workspace.

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.



¿Te ha sido útil este artículo?