> ## Documentation Index
> Fetch the complete documentation index at: https://squad.so/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Airtable

> What teammates can do in Airtable at each access level, and how to connect, limit, and disconnect Airtable.

Connect Airtable so your teammates can work in your Airtable account. You choose an access level for each account, and Squad refuses any teammate action outside that level.

## Access levels

Each Airtable account has an access level: **Read-only**, **Read + write**, and **Full access**. Squad refuses any teammate action outside that level. You can also narrow or block single teammates under **One teammate at a time**.

| Level | The connect window describes this level as | Actions teammates can use |
| - | - | - |
| **Read-only** | "Read everything this account can see, such as bases, records, and comments. Cannot change anything." | 8 of 27 |
| **Read + write** (recommended) | "Create and edit records, comments, and attachments, and delete comments. Cannot delete records or change bases, tables, or fields." | 20 of 27 |
| **Full access** | "Everything, including deleting records and creating or changing bases, tables, and fields." | 27 of 27 |

**Read + write** is the recommended level. The connect window selects it for you, and you can choose another level.

The Airtable sign-in page asks you to approve full access to your account. This is expected. Squad does not narrow the sign-in. It checks every teammate action against the level you chose, and it refuses actions outside that level.

## What teammates can do at each level

Each level opens with a short summary in plain tasks, then lists every action it adds, grouped by what the action works on. You do not need to name actions. Ask in plain words, and the teammate searches for the matching action.

> [!TIP]
>
> **Find an action.** Open a level and use your browser's find (Ctrl+F, or Cmd+F on a Mac) with a word from the task or part of a slug. Or ask a teammate in plain words, for example "What can you do in my Airtable account?" The teammate can search the Airtable actions for you, and it can see which levels run each action.

Each action shows its name, a one-line description where the Airtable action catalog has one, and its slug. The slug is the ID that teammates use when they call the action.

> [accordion] Read-only
>
> Teammates can use 8 of the 27 Airtable actions at this level:
>
> * View records
> * View account details
> * View attachments
> * View bases
> * View comments
> * View schemas
> * View users
>
> All 8 actions at this level:
>
> | Works on | Action | What it does | Slug |
> | - | - | - | - |
> | **Account details** | Who am I | | `AIRTABLE_WHO_AM_I` |
> | **Attachments** | Get attachment info | | `AIRTABLE_GET_ATTACHMENT_INFO` |
> | **Bases** | List bases | Retrieves all Airtable bases accessible to the authenticated user, which may include an 'offset' for pagination. | `AIRTABLE_LIST_BASES` |
> | **Comments** | List comments | List comments on a specific Airtable record. | `AIRTABLE_LIST_COMMENTS` |
> | **Records** | Get record | Retrieves a specific record from an Airtable table by its record ID. | `AIRTABLE_GET_RECORD` |
> | | List records | List records from an Airtable table with filtering, sorting, and pagination. | `AIRTABLE_LIST_RECORDS` |
> | **Schemas** | Get base schema | Retrieves the detailed schema for a specified Airtable base, including its tables, fields, field types, and configurations, using the baseId. | `AIRTABLE_GET_BASE_SCHEMA` |
> | **Users** | Get user info | Retrieves information, such as ID and permission scopes, for the currently authenticated Airtable user from the /meta/whoami endpoint. | `AIRTABLE_GET_USER_INFO` |

> [accordion] Read + write (recommended)
>
> Teammates can use 20 of the 27 Airtable actions at this level: everything in **Read-only**, plus:
>
> * Create and update records
> * Create, update, and delete comments
> * Create attachments
>
> The 12 actions that this level adds to **Read-only**:
>
> | Works on | Action | What it does | Slug |
> | - | - | - | - |
> | **Attachments** | Upload attachment | Uploads a file attachment to a specified field in an Airtable record. | `AIRTABLE_UPLOAD_ATTACHMENT` |
> | **Comments** | Create comment | Create a comment on a specific Airtable record. | `AIRTABLE_CREATE_COMMENT` |
> | | Delete comment | Delete a comment from a record in an Airtable table. | `AIRTABLE_DELETE_COMMENT` |
> | | Update comment | Update an existing comment on a specific Airtable record. | `AIRTABLE_UPDATE_COMMENT` |
> | **Records** | Create multiple records | DEPRECATED: Use AIRTABLE\_CREATE\_RECORDS instead. | `AIRTABLE_CREATE_MULTIPLE_RECORDS` |
> | | Create record | DEPRECATED: Use CreateRecords instead. | `AIRTABLE_CREATE_RECORD` |
> | | Create record from natural language | Creates a new record in an Airtable table from a natural language description. | `AIRTABLE_CREATE_RECORD_FROM_NATURAL_LANGUAGE` |
> | | Create records | Create multiple records (up to 10) in a specified Airtable table. | `AIRTABLE_CREATE_RECORDS` |
> | | Update multiple records | Update up to 10 records in an Airtable table with selective field modifications. | `AIRTABLE_UPDATE_MULTIPLE_RECORDS` |
> | | Update multiple records put | Destructively update multiple records in Airtable using PUT, clearing unspecified fields. | `AIRTABLE_UPDATE_MULTIPLE_RECORDS_PUT` |
> | | Update record | Modifies specified fields of an existing record in an Airtable base and table. | `AIRTABLE_UPDATE_RECORD` |
> | | Update record put | Updates an existing record in an Airtable base using PUT method. | `AIRTABLE_UPDATE_RECORD_PUT` |

> [accordion] Full access
>
> Teammates can use 27 of the 27 Airtable actions at this level: everything in **Read + write**, plus:
>
> * Create and update fields
> * Delete records
> * Create and update tables
> * Create bases
>
> The 7 actions that this level adds to **Read + write**:
>
> | Works on | Action | What it does | Slug |
> | - | - | - | - |
> | **Bases** | Create base | Creates a new Airtable base with specified tables and fields within a workspace. | `AIRTABLE_CREATE_BASE` |
> | **Fields** | Create field | Creates a new field within a specified table in an Airtable base. | `AIRTABLE_CREATE_FIELD` |
> | | Update field | Updates a field's name or description in an Airtable table. | `AIRTABLE_UPDATE_FIELD` |
> | **Records** | Delete multiple records | Delete up to 10 specified records from a table within an Airtable base. | `AIRTABLE_DELETE_MULTIPLE_RECORDS` |
> | | Delete record | Permanently deletes a specific record from an existing table within an existing Airtable base. | `AIRTABLE_DELETE_RECORD` |
> | **Tables** | Create table | Creates a new table within a specified existing Airtable base, allowing definition of its name, description, and field structure. | `AIRTABLE_CREATE_TABLE` |
> | | Update table | Updates the name, description, and/or date dependency settings of a table in Airtable. | `AIRTABLE_UPDATE_TABLE` |

## Connect Airtable

Before you start:

* You need an Airtable account that you can sign in to.
* Your Squad subscription must be active. Squad does not connect apps while the subscription is not active.

**1. Open Apps**

Click **Settings** at the bottom of the sidebar, then **Apps**.

**2. Add an integration**

Under **Connected apps**, click the **Add integration** card.

**3. Find Airtable**

Find **Airtable** in the catalog and click it. You can type the name in **Search the catalog**.

**4. Choose an access level**

Under **What every teammate can do**, choose an access level. It applies to every teammate. The recommended level is marked **Recommended**.

**5. Choose who may use it**

If other people are in your squad, the window also shows **Share this account with everyone in this squad**. It is ticked for the owner and clear for everyone else. Leave it ticked to let your teammates use the account for anyone's requests. Clear it to keep the account for your own requests.

**6. Click Connect Airtable**

Click **Connect Airtable**. The Airtable sign-in page opens in a new tab.

**7. Sign in to Airtable**

Sign in to Airtable and approve the request. The Squad window waits and closes by itself when the account shows up.

Check that it works: Airtable shows under **Your connections** in its own card, with a row for the account and its access level.

## Change the access level

1. Under **Your connections**, find the Airtable account.
2. Click the access level on the account row, or open the account menu (⋯) and click **Manage scope**. Both open the same window.
3. Under **What every teammate can do**, choose the new level.
4. Click **Save access**.

The change does not need a new sign-in. Teammates get the new level from their next call.

## Set access for one teammate

Every teammate uses the account's level unless you set something else for it. You can narrow one teammate to a lower level, or block it.

Only you and your Administrators see **One teammate at a time**. The window says "Each teammate can do what’s set above unless you choose otherwise here. A change applies from their next use of it."

1. Under **Your connections**, open the account menu (⋯) on the Airtable account.
2. Click **Manage scope**.
3. Under **One teammate at a time**, find the teammate.
4. Choose **Default (level name)** to follow the account's level, choose any level of the app, or choose **No access**.
5. Click **Save access**.

A teammate never gets more than the account's level, even if you choose a higher level for it. Changes apply from the teammate's next call. A teammate with **No access** does not see the account.

## Use more than one Airtable account

Click **+ Account** on the Airtable card to connect another account. Teammates try the main account first unless they are asked to use a specific one. When other people are in your squad, a person's own accounts come before shared accounts.

* After you click **+ Account**, follow the connect steps above.
* Each account has its own access level.
* The first account you connect becomes the main account. Its row shows **Main account**.
* To change the main account, open the account menu (⋯) and click **Make it the main account**. Only you and the Administrators who can see every teammate can do this.
* To tell accounts apart, open the account menu (⋯) and click **Rename**.
* Each account is private to the person who connected it unless that person shares it. When other people are in your squad, connecting an account asks whether to share it with everyone. See [Who can use an account](https://squad.so/docs/integrations.md#who-can-use-an-account).

## Reconnect or disconnect

Reconnect when the connection has expired, or when you need to change what the account can reach on the Airtable side:

1. Open the account menu (⋯) and click **Reconnect**.
2. Click **Reauthorize on Airtable**.
3. Sign in to Airtable and approve the request.

Reconnect signs in to the same account again. It does not add a second connection. Only the person who connected the account can reconnect it. An account whose sign-in has expired shows **Needs reconnecting** on its row, with a **Reconnect** button for the person who connected it.

Open the account menu (⋯) on the Airtable account and click **Disconnect…**. A dialog asks you to confirm and says "Your teammates lose access to Airtable through this account." Click **Disconnect**. Teammates then lose access to that account at once.

If it was the main account, another connected Airtable account becomes the main account.

## Costs

Airtable actions do not use Squad credits. Connected apps never use credits. For what does use credits, see [What Squad costs](https://squad.so/docs/costs.md).

## Troubleshooting

A teammate reports that an action is not allowed on this account.

* Cause: the action is outside the account's access level, or outside the level you set for that teammate.
* Fix: choose a higher level in **Manage scope**. You or an Administrator can also change the teammate's row under **One teammate at a time**.

A teammate says it has no access to Airtable, or it does not see the account.

* Cause: the teammate is set to **No access** under **One teammate at a time**, or the account is not connected.
* Fix: you or an Administrator opens **Manage scope** and changes the teammate's row. If the account is missing, connect it again.

Connecting or saving fails with "Your subscription isn't active."

* Cause: your Squad subscription is not active.
* Fix: resubscribe. See [Manage your subscription](https://squad.so/docs/billing.md).

A teammate says the Airtable connection has expired.

* Cause: the sign-in for that account is no longer valid.
* Fix: click **Reconnect** on the account row, or open the account menu (⋯) and click **Reconnect**.

## Common questions

> [accordion] Can I limit what teammates can do in Airtable?
>
> Each Airtable account has an access level: **Read-only**, **Read + write**, and **Full access**. Squad refuses any teammate action outside that level. You can also narrow or block single teammates under **One teammate at a time**.

> [accordion] Can I connect more than one Airtable account?
>
> Click **+ Account** on the Airtable card to connect another account. Teammates try the main account first unless they are asked to use a specific one. When other people are in your squad, a person's own accounts come before shared accounts.

> [accordion] How do I disconnect Airtable?
>
> Open the account menu (⋯) on the Airtable account and click **Disconnect…**. A dialog asks you to confirm and says "Your teammates lose access to Airtable through this account." Click **Disconnect**. Teammates then lose access to that account at once.

## Related pages

> [card] [Connect apps](https://squad.so/docs/integrations.md)

> [card] [Add an MCP server or an API key](https://squad.so/docs/custom-integrations.md)
>
> Use this when an action you need is not in this app.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.