---
title: Airtable modules
slug: airtable-modules
image: https://make-cxp-documentation.ams3.cdn.digitaloceanspaces.com/apps-center-icons/PREVIEW_DEFAULT.png
createdAt: 2025-03-11T14:43:21.894Z
---

After connecting to the Airtable app, you can use the following modules to build your scenarios.&#x20;

# Records

:::ExpandableHeading
## Watch Records

Returns all newly created or updated records in a view (required **Created Time** or **Last Modified Time** fields).

| **Field**                 | **Description**                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**            | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| **Base**                  | Select the base that contains the table you want to watch for records.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| **Table**                 | Select the table you want to watch for new records.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| **Trigger configuration** | **Trigger field**<br />Select the `Created Time` option to watch for new records or the `Last Modified Time` option to watch for modified records.<br />If you do not have a `Created Time` or `Last Modified Time` field in your scheme, we ask you to create one. Without this field, the trigger will not work correctly.<br />:inlineImage[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/TqF18vGm45LHPo_BPyEyx_uuid-3a4f25a6-dd67-7cf1-9839-62036be9d3b3.gif" alt="Trigger field" caption}<br />**Label field**: used as a label for a record. For example, **Status** dialog.<br />:inlineImage[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/EEGGU6Ut3Ns7VkM_nH7fl_uuid-4cc74a20-4960-6f2c-39d5-02b096e248fc.png" alt caption} |
| **Limit**                 | The maximum number of records Make will return during one execution cycle.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| **View**                  | Select the view to watch the records. If selected, it will return the records only in that view.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| **Formula**               | Enter the formula to filter records. For more details, refer to the [Formula field reference documentation](https://support.airtable.com/hc/en-us/articles/203255215-Formula-Field-Reference).<br />The formula will be evaluated for each record, and if the result is not `0`, `false`, `""`, `NaN`, `[]`, or `#Error!`, includes the record in the response.<br />If combined with the `view` parameter, it returns only records in that view that satisfy the formula.<br />For example, to only include records where Name isn't empty, pass in `NOT({Name} = '')` as a parameter like this:<br />`filterByFormula=NOT%28%7BName%7D%20%3D%20%27%27%29`                                                                                                                  |
| **Use Column ID**         | Select whether to use column ID instead of column name for mapping.<br />This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.                                                                                                                                                                                                                                                                                                                                                                                                          |
:::

:::::ExpandableHeading
## Watch Responses

Triggers when a new response is submitted.

:::hint{type="info"}
Available on the **Team&#x20;**&#x70;lan and all higher **Airtable&#x20;**&#x74;iers. See the [Airtable pricing page](https://airtable.com/pricing).
:::

The webhook URL needs to be generated in Make and added to the form configuration in the Airtable.

::::WorkflowBlock
:::WorkflowBlockItem
Add the Watch Responses module to your Make scenario.
:::

:::WorkflowBlockItem
Generate and copy the webhook URL.
:::

:::WorkflowBlockItem
Log in to your Airtable account.
:::

:::WorkflowBlockItem
Open the **Base** and the **Table** you want for the form.
:::

:::WorkflowBlockItem
In the left sidebar, click **Forms+&#x20;**&#x75;nder **Create**.

![](https://api.archbee.com/api/optimize/PL8X94efBsjvhfQV3wyyj-hwmUNResBkkxCUtlMwkas-20250703-143733.png)
:::

:::WorkflowBlockItem
Set the form as needed, and click its name.
:::

:::WorkflowBlockItem
Under **Submission options&#x20;**&#x69;n the right sidebar, enable the **Redirect to URL &#x20;**&#x6F;ption.
:::

:::WorkflowBlockItem
In the **URL** field, enter the Webhook URL generated in step 2 and add the `?record_id={record_id}` just after the webhook URL to include the **Record ID** in the module's output.

![](https://api.archbee.com/api/optimize/PL8X94efBsjvhfQV3wyyj-ux-P9rIp4slKrAHiXHmkt-20250703-144218.png)
:::

:::WorkflowBlockItem
Click **Save**.&#x20;

The resulting URL will, for example, look like this:`https://hook.eu1.make.com/tgnp28pewooafbdgobvbh225hmocbn85?record_id={record_id}`
:::

:::WorkflowBlockItem
Go back to your Make scenario and run the **Watch Responses** module **only** to load the Record ID from Airtable and to be able to map that field into the other modules.&#x20;

Airtable only supports sending the `record_id` parameter.
:::

:::WorkflowBlockItem
Submit the form in Airtable where the **Redirect to URL** option is enabled and the Webhook URL is added (steps 7-9).

The Watch Responses module is triggered and loads the Record ID.
:::
::::

You can now add another module after the **Watch Responses** module and map the `record_id` to the **Record ID** field.
:::::

:::ExpandableHeading
## Search Records

Searches for specific records or returns all records.

| **Field**         | **Description**                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| ----------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**    | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| **Base**          | Select or map the base that contains the table you want to search for records.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| **Table**         | Select the table you want to search for records.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| **Formula**       | Enter the formula to filter records. For more details, refer to the [Formula field reference documentation](https://support.airtable.com/hc/en-us/articles/203255215-Formula-Field-Reference).<br />The formula will be evaluated for each record, and if the result is not `0`, `false`, `""`, `NaN`, `[]`, or `#Error!`, includes the record in the response.<br />If combined with the `view` parameter, it returns only records in that view that satisfy the formula.<br />For example, to only include records where Name isn't empty, pass in `NOT({Name} = '')` as a parameter like this:<br />`filterByFormula=NOT%28%7BName%7D%20%3D%20%27%27%29` |
| **Sort**          | Specify sorting, if needed. The higher item in the list has precedence.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| **View**          | Select or map the view for the search results.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| **Output Fields** | Add the fields you want to receive in the output. If no field is provided, all fields will be returned. It can be the field's name, for example, `Email`, or the field's ID, for example, `fldzuOSozlM84fYV3`.                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| **Limit**         | Set the maximum number of records Make will return during one execution cycle. The default value is 10.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| **Use Column ID** | Select whether to use column ID instead of column name for mapping.<br />This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.                                                                                                                                                                                                                                                                                         |
:::

:::ExpandableHeading
## Get a Record

Retrieves a single record by its ID.

| **Field**         | **Description**                                                                                                                                                                                                                                                                                                                                                     |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**    | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                                                                                |
| **Base**          | Select or map the base that contains the table you want to get a record from.                                                                                                                                                                                                                                                                                       |
| **Table**         | Select the table you want to get a record from.                                                                                                                                                                                                                                                                                                                     |
| **Record ID**     | Enter (map) the Record ID whose details you want to retrieve. Alternatively, you can use the search option to select the record.                                                                                                                                                                                                                                    |
| **Use Column ID** | Select whether to use column ID instead of column name for mapping.<br />This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario. |
:::

:::ExpandableHeading
## Create a Record

Creates a new record in a Airtable.

| **Field**         | **Description**                                                                                                                                                                                                                                                                                                                                                     |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**    | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                                                                                |
| **Base**          | Select or map the base that contains the table where you want to create a record.                                                                                                                                                                                                                                                                                   |
| **Table**         | Select the table where you want to create a record.                                                                                                                                                                                                                                                                                                                 |
| **Record**        | Enter values to the desired fields. [See Airtable's guide to basic field types](https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types).                                                                                                                                                                                           |
| **Smart links**   | Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.                                                                                                                                                                             |
| **Use Column ID** | Select whether to use column ID instead of column name for mapping.<br />This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario. |
:::

:::ExpandableHeading
## Update a Record

Updates a record by its ID.

| **Field**         | **Description**                                                                                                                                                                                                                                                                                                                                                     |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**    | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                                                                                |
| **Base**          | Select or map the base that contains the table whose records you want to update.                                                                                                                                                                                                                                                                                    |
| **Table**         | Select the table whose records you want to update.                                                                                                                                                                                                                                                                                                                  |
| **Record ID**     | Enter (map) the Record ID you want to update. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module. Alternatively, you can use the **Search** button to select the Record ID.                                                                                                                                             |
| **Record**        | Enter values to the desired fields. [See Airtable's guide to basic field types](https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types).<br />To delete the content of the field, use the `erase` function.                                                                                                                        |
| **Smart links**   | Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.                                                                                                                                                                             |
| **Use Column ID** | Select whether to use column ID instead of column name for mapping.<br />This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario. |
:::

:::ExpandableHeading
## Upload an attachment

Uploads an attachment into an attachment field. Only allows files up to 5 MB.

| **Field**                        | **Description**                                                                                                                                                                                                                                                                                                                                          |
| -------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**                   | [Connect a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                                                                                                                    |
| **Base**                         | Select or map the base that contains the table with the record you want to attach the file to.                                                                                                                                                                                                                                                           |
| **Table**                        | Select the table with the record you want to attach the file to.                                                                                                                                                                                                                                                                                         |
| **Record ID**                    | Enter (map) the ID of the record to attach the file to. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module. Alternatively, you can use the **ID finder** button to select the Record ID. In the ID finder, select a **Display field** to show records by, and optionally enter a **Formula** to filter them. |
| **Attachment field**             | Select the attachment field to upload the file to.                                                                                                                                                                                                                                                                                                       |
| **File name**                    | Enter the name of the file.                                                                                                                                                                                                                                                                                                                              |
| **Data**                         | Enter the file contents to upload. The maximum file size is 5 MB.                                                                                                                                                                                                                                                                                        |
| **Content type**                 | Select the content type of the file.                                                                                                                                                                                                                                                                                                                     |
| **Replace existing attachments** | By default, the module adds the new attachment to the field. If you enable this option, the module clears the existing attachments before adding the new one. This happens in two separate steps, so if the upload fails after the field is cleared, the field is left empty. This is an advanced setting.                                               |
:::

:::ExpandableHeading
## Upsert a Record

Creates a new or updates an existing record.

| **Field**         | **Description**                                                                                                                                                                                                                                                                                                                                                     |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**    | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                                                                                |
| **Base**          | Select or map the base that contains the table you want to update or create a record.                                                                                                                                                                                                                                                                               |
| **Table**         | Select the table where you want to create or update a record.                                                                                                                                                                                                                                                                                                       |
| **Record ID**     | Enter (map) the Record ID you want to update. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module. Alternatively, you can use the **Search** button to select the Record ID.<br />If you enter an ID that does not exist, an error occurs, and no action is performed.                                                   |
| **Record**        | Enter the values you want to update or create. [See Airtable's guide to basic field types](https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types).<br />To delete the content of the field, use the `erase` function.                                                                                                             |
| **Use Column ID** | Select whether to use column ID instead of column name for mapping.<br />This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario. |
:::

:::ExpandableHeading
## Delete a Record

Deletes a record by its ID.

| **Field**      | **Description**                                                                                                                                                                                                         |
| -------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection** | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                    |
| **Base**       | Select or map the base that contains the table you want to delete a record from.                                                                                                                                        |
| **Table**      | Select the table you want to delete the record from.                                                                                                                                                                    |
| **Record ID**  | Enter (map) the Record ID you want to delete. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module. Alternatively, you can use the **Search** button to select the Record ID. |
:::

:::ExpandableHeading
## Bulk Create Records (advanced)

Creates multiple records.

| **Field**                  | **Description**                                                                                                                                                                      |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Connection**             | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                 |
| **Create Records in Bulk** | Select the input method:<br />- Enter manually<br />- Select from the list                                                                                                           |
| **Base**                   | Select or map the base that contains the table you want to create records in.                                                                                                        |
| **Table**                  | Select the table in which you want to create the records.                                                                                                                            |
| **Records**                | Enter values in the fields you want to create. [See Airtable's guide to basic field types](https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types). |
:::

:::ExpandableHeading
## Bulk Update Records (advanced)

Updates multiple existing records.

| **Field**                  | **Description**                                                                                                                                                                      |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Connection**             | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                 |
| **Update Records in Bulk** | Select the input method:<br />- Enter manually<br />- Select from the list                                                                                                           |
| **Base**                   | Select or map the base that contains the table whose records you want to update.                                                                                                     |
| **Table**                  | Select the table in which you want to update the records.                                                                                                                            |
| **Records**                | Enter values in the fields you want to update. [See Airtable's guide to basic field types](https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types). |
:::

:::ExpandableHeading
## Bulk Upsert Records (advanced)

Upserts multiple records.

| **Field**                  | **Description**                                                                                                                                                                      |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Connection**             | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                 |
| **Upsert Records in Bulk** | Select the input method:<br />- Enter manually<br />- Select from the list                                                                                                           |
| **Base**                   | Select or map the base that contains the table where you want to upsert records                                                                                                      |
| **Table**                  | Select the table in which you want to upsert records.                                                                                                                                |
| **Fields to Merge on**     | Enter at least one and at most three field names or IDs to uniquely identify a single record.                                                                                        |
| **Records**                | Enter values in the fields you want to upsert. [See Airtable's guide to basic field types](https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types). |
:::

:::ExpandableHeading
## Bulk Delete Records (advanced)

Deletes multiple records.

| **Field**                  | **Description**                                                                                                                                                                                                             |
| -------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**             | [Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                        |
| **Delete Records in Bulk** | Select the input method:<br />- Enter manually<br />- Select from the list                                                                                                                                                  |
| **Base**                   | Select or map the base that contains the table where you want to delete records.                                                                                                                                            |
| **Table**                  | Select the table for which you want to delete records.                                                                                                                                                                      |
| **Record ID**              | Enter the IDs of the record you want to delete. You can retrieve the IDs, for example, using the **Search Records** or **Watch Records** module. Alternatively, you can use the **Search** button to select the Record IDs. |
:::

# Schema

:::ExpandableHeading
## List bases

Returns a detailed list of all bases.

| **Field**      | **Description**                                                                                      |
| -------------- | ---------------------------------------------------------------------------------------------------- |
| **Connection** | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and) |
| **Limit**      | Set the maximum number of bases to return during one execution cycle. The default value is 10.       |
:::

:::ExpandableHeading
## Create a base

Creates a new base.

| **Field**             | **Description**                                                                                                                                                                                                                                                                                                 |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                                                                            |
| **Base name**         | Enter the name of the new base.                                                                                                                                                                                                                                                                                 |
| **Workspace ID**      | The workspace where the base will be created. Enter the full workspace ID including the `wsp` prefix, for example `wspXXXXXXXXXXXXXX`. You can find it in the URL of the workspace, for example `https://airtable.com/workspaces/wspXXXXXXXXXXXXXX`. Do not include the question mark or anything after the ID. |
| **Tables**            | Add the tables of the new base.                                                                                                                                                                                                                                                                                 |
| **Table name**        | Enter the name of the table.                                                                                                                                                                                                                                                                                    |
| **Table description** | Enter a description for the table.                                                                                                                                                                                                                                                                              |
| **Fields**            | Add the fields of the table.                                                                                                                                                                                                                                                                                    |
| **Field name**        | Enter the name of the field. Field names must be unique within the table (case-insensitive).                                                                                                                                                                                                                    |
| **Field description** | Enter a description for the field.                                                                                                                                                                                                                                                                              |
| **Field type**        | Select the field type. The primary field only allows a subset of field types.                                                                                                                                                                                                                                   |

**Field type settings**

The settings that appear depend on the **Field type** you select.

| **Field type**             | **Settings**                                                                                                                                                                                  |
| -------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Attachment**             | No additional settings.                                                                                                                                                                       |
| **Barcode**                | No additional settings.                                                                                                                                                                       |
| **Checkbox**               | **Color**: The color of the checkbox.<br />**Icon**: The icon name of the checkbox.                                                                                                           |
| **Currency**               | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.<br />**Currency symbol**: Currency symbol to use.    |
| **Date**                   | **Date format name**: Select the date format.                                                                                                                                                 |
| **Date and time**          | **Timezone**: Select the time zone of the field.<br />**Date format name**: Select the date format.<br />**Time format name**: Select the time format.                                        |
| **Duration**               | **Duration format**: Select the duration format.                                                                                                                                              |
| **Email**                  | No additional settings.                                                                                                                                                                       |
| **Link to another record** | **Linked table**: Select the table the field links to.<br />**View for record selection**: Select the view in the linked table to use when showing a list of records to select from.          |
| **Long text**              | No additional settings.                                                                                                                                                                       |
| **Multiple collaborators** | No additional settings.                                                                                                                                                                       |
| **Multiple select**        | **Choices**: Add the options people can select.<br />**Choice name**: Enter the name of the choice.<br />**Color**: The color of this choice.                                                 |
| **Number**                 | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.                                                      |
| **Percent**                | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.                                                      |
| **Phone number**           | No additional settings.                                                                                                                                                                       |
| **Rating**                 | **Color**: The color of selected icons.<br />**Icon**: The icon name used to display the rating.<br />**Maximum rating value**: The maximum value for the rating. Enter a value from 1 to 10. |
| **Rich text**              | No additional settings.                                                                                                                                                                       |
| **Single collaborator**    | No additional settings.                                                                                                                                                                       |
| **Single line text**       | No additional settings.                                                                                                                                                                       |
| **Single select**          | **Choice name**: Enter the name of the choice.<br />**Color**: The color of this choice.                                                                                                      |
| **URL**                    | No additional settings.                                                                                                                                                                       |
:::

:::ExpandableHeading
## Create a table

Creates a new table.

| **Field**             | **Description**                                                                                      |
| --------------------- | ---------------------------------------------------------------------------------------------------- |
| **Connection**        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and) |
| **Base**              | Select or map the base where you want to create the table.                                           |
| **Table name**        | Enter the name of the new table.                                                                     |
| **Table description** | Enter a description for the table.                                                                   |
| **Fields**            | Add the fields of the table.                                                                         |
| **Field name**        | Enter the name of the field. Field names must be case-insensitive unique names within the table.     |
| **Field description** | Enter a description for the field.                                                                   |
| **Field type**        | Select the field type. The primary field only allows a subset of field types.                        |

**Field type settings**

The settings that appear depend on the **Field type** you select:

| **Field type**             | **Settings**                                                                                                                                                                                                                                             |
| -------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Attachment**             | No additional settings.                                                                                                                                                                                                                                  |
| **Barcode**                | No additional settings.                                                                                                                                                                                                                                  |
| **Checkbox**               | **Color**: The color of the checkbox.<br />**Icon**: The icon name of the checkbox.                                                                                                                                                                      |
| **Currency**               | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.<br />**Currency symbol**: Currency symbol to use.                                                               |
| **Date**                   | **Date format**: Configure the date format.<br />**Date format name**: Select the date format.                                                                                                                                                           |
| **Date and time**          | **Timezone**: Select the time zone of the field.<br />**Date format**: Configure the date format.<br />**Date format name**: Select the date format.<br />**Time format**: Configure the time format.<br />**Time format name**: Select the time format. |
| **Duration**               | **Duration format**: Select the duration format.                                                                                                                                                                                                         |
| **Email**                  | No additional settings.                                                                                                                                                                                                                                  |
| **Link to another record** | **Linked table**: Select the table the field links to.<br />**View for record selection**: Select the view in the linked table to use when showing a list of records to select from.                                                                     |
| **Long text**              | No additional settings.                                                                                                                                                                                                                                  |
| **Multiple collaborators** | No additional settings.                                                                                                                                                                                                                                  |
| **Multiple select**        | **Choices**: Add the options people can select.<br />**Choice name**: Enter the name of the choice.<br />**Color**: The color of this choice.                                                                                                            |
| **Number**                 | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.                                                                                                                 |
| **Percent**                | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.                                                                                                                 |
| **Phone number**           | No additional settings.                                                                                                                                                                                                                                  |
| **Rating**                 | **Color**: The color of selected icons.<br />**Icon**: The icon name used to display the rating.<br />**Maximum rating value**: The maximum value for the rating. Enter a value from 0 to 10.                                                            |
| **Rich text**              | No additional settings.                                                                                                                                                                                                                                  |
| **Single collaborator**    | No additional settings.                                                                                                                                                                                                                                  |
| **Single line text**       | No additional settings.                                                                                                                                                                                                                                  |
| **Single select**          | **Choices**: Add the options people can select.<br />**Choice name**: Enter the name of the choice.<br />**Color**: The color of this choice.                                                                                                            |
| **URL**                    | No additional settings.                                                                                                                                                                                                                                  |
:::

:::ExpandableHeading
## Update a table

Updates the name, description, and/or date dependency settings of a table.

| **Field**                             | **Description**                                                                                      |
| ------------------------------------- | ---------------------------------------------------------------------------------------------------- |
| **Connection**                        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and) |
| **Base**                              | Select the base that contains the table you want to update.                                          |
| **Table**                             | Select the table you want to update.                                                                 |
| **Name**                              | Enter the new name of the table.                                                                     |
| **Description**                       | Enter the new description of the table. The maximum is 20,000 characters.                            |
| **Date dependency settings**          | Configure whether date dependency settings are enabled.                                              |
| **Start date field**                  | Select the date field that holds the start date.                                                     |
| **End date field**                    | Select the date field that holds the end date.                                                       |
| **Duration field**                    | Map the duration field.                                                                              |
| **Predecessor field**                 | Map the field that links to the predecessor records.                                                 |
| **Rescheduling mode**                 | Select the rescheduling mode.                                                                        |
| **Should skip weekends and holidays** | Configure whether to skip weekends and holidays when recalculating.                                  |
| **Holidays**                          | Insert the holiday dates to skip when recalculating.                                                 |
:::

:::ExpandableHeading
## Create a field

Creates a new field in an existing table.

| **Field**             | **Description**                                                                                      |
| --------------------- | ---------------------------------------------------------------------------------------------------- |
| **Connection**        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and) |
| **Base**              | Select or map the base that contains the table where you want to create the field.                   |
| **Table**             | Select the table where you want to create the field.                                                 |
| **Field name**        | Enter the name of the field. Field names must be unique within the table (case-insensitive).         |
| **Field description** | Enter a description for the field.                                                                   |
| **Field type**        | Select the field type.                                                                               |

**Field type settings**

The settings that appear depend on the **Field type** you select.

| **Field type**             | **Settings**                                                                                                                                                                                  |
| -------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Attachment**             | No additional settings.                                                                                                                                                                       |
| **Barcode**                | No additional settings.                                                                                                                                                                       |
| **Checkbox**               | **Color**: The color of the checkbox.<br />**Icon**: The icon name of the checkbox.                                                                                                           |
| **Currency**               | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.<br />**Currency symbol**: Currency symbol to use.    |
| **Date**                   | **Date format name**: Select the date format.                                                                                                                                                 |
| **Date and time**          | **Timezone**: Select the time zone of the field.<br />**Date format name**: Select the date format.<br />**Time format name**: Select the time format.                                        |
| **Duration**               | **Duration format**: Select the duration format.                                                                                                                                              |
| **Email**                  | No additional settings.                                                                                                                                                                       |
| **Link to another record** | **Linked table**: Select the table the field links to.<br />**View for record selection**: Select the view in the linked table to use when showing a list of records to select from.          |
| **Long text**              | No additional settings.                                                                                                                                                                       |
| **Multiple collaborators** | No additional settings.                                                                                                                                                                       |
| **Multiple select**        | **Choices**: Add the options people can select.<br />**Choice name**: Enter the name of the choice.<br />**Color**: The color of this choice.                                                 |
| **Number**                 | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.                                                      |
| **Percent**                | **Decimal precision**: Indicates the number of digits shown to the right of the decimal point for this field. Enter a value from 0 to 7.                                                      |
| **Phone number**           | No additional settings.                                                                                                                                                                       |
| **Rating**                 | **Color**: The color of selected icons.<br />**Icon**: The icon name used to display the rating.<br />**Maximum rating value**: The maximum value for the rating. Enter a value from 0 to 10. |
| **Rich text**              | No additional settings.                                                                                                                                                                       |
| **Single collaborator**    | No additional settings.                                                                                                                                                                       |
| **Single line text**       | No additional settings.                                                                                                                                                                       |
| **Single select**          | **Choices**: Add the options people can select.<br />**Choice name**: Enter the name of the choice.<br />**Color**: The color of this choice.                                                 |
| **URL**                    | No additional settings.                                                                                                                                                                       |
:::

:::ExpandableHeading
## Update a field

Updates the name and/or description of a field.

| **Field**             | **Description**                                                                                      |
| --------------------- | ---------------------------------------------------------------------------------------------------- |
| **Connection**        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and) |
| **Base**              | Select or map the base that contains the table with the field you want to update.                    |
| **Table**             | Select the table with the field you want to update.                                                  |
| **Field**             | Select the field you want to update.                                                                 |
| **New name**          | Enter the new name of the field.                                                                     |
| **Field description** | Enter the new description of the field. The maximum is 20,000 characters.                            |
:::

:::ExpandableHeading
## Get base schema

Returns the base schema.

| **Field**      | **Description**                                                                                      |
| -------------- | ---------------------------------------------------------------------------------------------------- |
| **Connection** | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and) |
| **Base**       | Select or map the base whose structure you want to retrieve.                                         |
:::

# Comments

:::ExpandableHeading
## Create a comment

Creates a new comment.

| **Field**          | **Description**                                                                                                                                                                                                                                                                                                                                                |
| ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**     | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                                                                                                                           |
| **Base**           | Select or map the base that contains the table with the record you want to comment on.                                                                                                                                                                                                                                                                         |
| **Table**          | Select the table with the record you want to comment on.                                                                                                                                                                                                                                                                                                       |
| **Record ID**      | Enter (map) the ID of the record the comment belongs to. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module.<br />Alternatively, you can use the **ID finder** button to select the Record ID. In the ID finder, select a **Display field** to show records by, and optionally enter a **Formula** to filter them. |
| **Comment text**   | Enter the text of the comment.                                                                                                                                                                                                                                                                                                                                 |
| **Parent comment** | Select a comment to reply to. If you select a parent comment, the module creates a subcomment (a threaded reply).                                                                                                                                                                                                                                              |
:::

:::ExpandableHeading
## Update a comment

Updates an existing comment.

| **Field**             | **Description**                                                                                                                                                                                                                                                                                                                                           |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                                                                                                                      |
| **Base**              | Select or map the base that contains the table with the commented record.                                                                                                                                                                                                                                                                                 |
| **Table**             | Select the table with the commented record.                                                                                                                                                                                                                                                                                                               |
| **Record ID**         | Enter (map) the ID of the record the comment belongs to. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module. Alternatively, you can use the **ID finder** button to select the Record ID. In the ID finder, select a **Display field** to show records by, and optionally enter a **Formula** to filter them. |
| **Comment to update** | Select the comment you want to edit.                                                                                                                                                                                                                                                                                                                      |
| **Comment text**      | Enter the new text. It replaces the existing comment text.                                                                                                                                                                                                                                                                                                |
:::

:::ExpandableHeading
## Delete a comment

Deletes an existing comment. This action cannot be undone.

| **Field**             | **Description**                                                                                                                                                                                                                                                                                                                                                |
| --------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**        | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                                                                                                                           |
| **Base**              | Select or map the base that contains the table with the commented record.                                                                                                                                                                                                                                                                                      |
| **Table**             | Select the table with the commented record.                                                                                                                                                                                                                                                                                                                    |
| **Record ID**         | Enter (map) the ID of the record the comment belongs to. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module.<br />Alternatively, you can use the **ID finder** button to select the Record ID. In the ID finder, select a **Display field** to show records by, and optionally enter a **Formula** to filter them. |
| **Comment to delete** | Select the comment you want to delete.                                                                                                                                                                                                                                                                                                                         |
:::

:::ExpandableHeading
## List comments

Returns a list of comments for a specific record.

| **Field**      | **Description**                                                                                                                                                                                                                                                                                                                                                |
| -------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection** | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                                                                                                                           |
| **Base**       | Select or map the base that contains the table with the record whose comments you want to retrieve.                                                                                                                                                                                                                                                            |
| **Table**      | Select the table with the record whose comments you want to retrieve.                                                                                                                                                                                                                                                                                          |
| **Record ID**  | Enter (map) the ID of the record the comment belongs to. You can retrieve the ID, for example, using the **Search Records** or **Watch Records** module.<br />Alternatively, you can use the **ID finder** button to select the Record ID. In the ID finder, select a **Display field** to show records by, and optionally enter a **Formula** to filter them. |
| **Limit**      | Set the maximum number of comments to return during one execution cycle. The default value is 10.                                                                                                                                                                                                                                                              |
:::

:::ExpandableHeading
## Watch new comments

Triggers when a new comment is added to a record.

| **Field**      | **Description**                                                                                                                                                                                                                                                 |
| -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection** | [Create a connection to your Airtable account.](https://apps.make.com/airtable#connect-airtable-and)                                                                                                                                                            |
| **Base**       | Select the base that contains the table with the record you want to watch for new comments.                                                                                                                                                                     |
| **Table**      | Select the table with the record you want to watch for new comments.                                                                                                                                                                                            |
| **Record ID**  | Enter the ID of the record you want to watch for new comments. Alternatively, you can use the **ID finder** button to select the Record ID. In the ID finder, select a **Display field** to show records by, and optionally enter a **Formula** to filter them. |
| **Limit**      | The maximum number of comments to return during one execution cycle. The default value is 10.                                                                                                                                                                   |
:::

# Other

:::ExpandableHeading
## Make an API Call

Allows you to perform a custom API call.

| **Field**        | **Description**                                                                                                                                                                                                                                                                                                   |
| ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Connection**   | **[Create a connection to your Airtable account](https://apps.make.com/airtable#connect-airtable-and).                                                                                                                                                                                                            |
| **URL**          | Enter a path relative to `https://api.airtable.com/`. For example, `/v0/{base_id}/{table_id}`.<br />For the list of available endpoints, refer to the [Airtable REST API Documentation](https://airtable.com/api).                                                                                                |
| **Method**       | Select the HTTP method you want to use:<br />- **GET**<br />- to retrieve information for an entry.<br />- **POST**<br />- to create a new entry.<br />- **PUT**<br />- to update/replace an existing entry.<br />- **PATCH**<br />- to make a partial entry update.<br />- **DELETE**<br />- to delete an entry. |
| **Headers**      | Enter the desired request headers. You don't have to add authorization headers; we already did that for you.                                                                                                                                                                                                      |
| **Query String** | Enter the request query string.                                                                                                                                                                                                                                                                                   |
| **Body**         | Enter the body content for your API call.                                                                                                                                                                                                                                                                         |
:::

