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

# Airtable

> Deliver scheduled reports into an Airtable table: add new rows each run, or keep one live row per item

Choose **Airtable** on a schedule to write each run into a table in one of your Airtable bases. Stockful can build the table for you from the report's columns, or map into a table you already have.

## Connect your Airtable account

Pick **Airtable** as the channel, then **Connect Airtable** and approve access. The connection is **per user**: each staff member connects their own Airtable account, and a schedule delivers through the account of whoever set it up. When Airtable asks which base to share, pick at least one, or Stockful will not see any.

## Choose a base and table

First pick the **base** (Airtable's word for a workbook). Stockful cannot create a base for you, so if the list is empty, create one in Airtable first, then refresh.

Then choose the **table**:

* **Create a new table from this report** is the simplest: Stockful builds a table whose columns exactly match the report, each with the right type (text, number, or date). There is nothing to map.
* **Use an existing table** writes into a table you already have. You then map the report's columns onto its fields, as below.

## Map columns to fields

When you use an existing table, Stockful shows one row per report column, each with a dropdown of the table's fields (Airtable's word for columns). Where a report column and a field share the same name, Stockful matches them for you. For the rest, pick the field to write into, or choose **Not sent** to skip that column. Only mapped columns are written, so anything left as **Not sent** is simply left out.

## Add rows or update rows

The **On each run** setting decides what happens every run:

| Mode            | Each run                                                                                          |
| --------------- | ------------------------------------------------------------------------------------------------- |
| **Add rows**    | Adds the report's rows to the table, building up a history.                                       |
| **Update rows** | Updates the row for each item instead of adding duplicates, so you keep one current row per item. |

For **Update rows**, pick a **key field**: the column that identifies a row, like SKU. Stockful tracks the record it created for each key and updates that same record on the next run, so it never depends on the key being unique and never fails on a schedule. If you delete a tracked row in Airtable, it is recreated on the next run.

## Send now

**[Send now](/user-guide/reports/scheduling#send-now)** works for Airtable schedules, so you can fire a test delivery on demand and check the result before the first scheduled run.