### Example Interface ID URL

Source: https://support.airtable.com/docs/finding-airtable-ids

An example of an Airtable interface URL, highlighting the location of the interface ID.

```text
https://airtable.com/appeqX9XTkHZNfSbn/pagIk60ZUF9P5UP72/
```

--------------------------------

### Example Workspace ID URL

Source: https://support.airtable.com/docs/finding-airtable-ids

An example of an Airtable workspace URL, highlighting the location of the workspace ID.

```text
https://airtable.com/workspaces/wspqrdtEQXErvBMXXU?
```

--------------------------------

### Example Interface ID in Admin Panel

Source: https://support.airtable.com/docs/finding-airtable-ids

An example of an interface ID as displayed in the Airtable admin panel.

```text
pbdxBwNfbZXGVkoK
```

--------------------------------

### GET Request for Table Records

Source: https://support.airtable.com/docs/enforcement-of-url-length-limit-for-web-api-requests

Example of a GET request to retrieve table records with multiple query parameters. Ensure your API key is included in the Authorization header.

```curl
curl https://api.airtable.com/v0/BASE_ID/TABLE_ID_OR_NAME?cellFormat=string&fields%5B%5D=Field1&fields%5B%5D=Field2&maxRecords=50&pageSize=10&filterByFormula=%7BDays%20overdue%7D%20%3E%203 \
  -H "Authorization: Bearer YOUR_API_KEY"
```

--------------------------------

### Example String for FIND() and SEARCH()

Source: https://support.airtable.com/docs/finding-and-replacing-text

This is a sample string used to demonstrate the FIND() and SEARCH() functions.

```plaintext
Hello, world!
```

--------------------------------

### List Records (with Pagination)

Source: https://support.airtable.com/docs/public-rest-api

This example demonstrates how to list records from a table, including how to handle pagination using the 'offset' query parameter to retrieve all records in pages of up to 100.

```APIDOC
## GET /v0/{appId}/{tableName}

### Description
Retrieves a list of records from a specified table. Results are paginated, returning up to 100 records at a time. Use the `offset` query parameter to fetch subsequent pages.

### Method
GET

### Endpoint
`https://api.airtable.com/v0/{appId}/{tableName}`

### Parameters
#### Query Parameters
- **offset** (string) - Optional - An offset value obtained from a previous response to retrieve the next page of records.
- **pageSize** (integer) - Optional - The number of records to retrieve per page. Defaults to 100, with a maximum of 100.

### Request Example
`https://api.airtable.com/v0/appxxx/TableName`

### Response
#### Success Response (200)
- **records** (array) - A list of records.
- **offset** (string) - An offset value to be used for fetching the next page of records. This field is absent if there are no more pages.

#### Response Example
```json
{
  "records": [
    {
      "id": "recxxxx",
      "fields": { ... }
    }
  ],
  "offset": "itrSJ1l4jlPyxEG6c/recxxx"
}
```

#### Success Response (200) - Last Page
- **records** (array) - A list of records.

#### Response Example - Last Page
```json
{
  "records": [
    {
      "id": "recxxxx",
      "fields": { ... }
    }
  ]
}
```
```

--------------------------------

### Add Duration to Start Date Formula

Source: https://support.airtable.com/docs/duration-field-type

Example formula to add the value from a 'Duration' field to a 'Start Date' field in Airtable. Duration values are stored in seconds.

```airtable-formula
DATEADD({Start Date}, {Duration field}, "seconds")
```

--------------------------------

### Example Prompt with Airtable Fields

Source: https://support.airtable.com/docs/using-airtable-ai-in-long-text-fields

Demonstrates how to include Airtable fields within a prompt to provide specific context for the AI. The field names are represented as tokens that update automatically.

```Plain text
Write an email that addresses the following customer feedback: {customer_feedback}
```

```Plain text
Create a meeting summary based on the following notes: {Meeting Notes}
```

--------------------------------

### GET Request Using a Filtered View

Source: https://support.airtable.com/docs/enforcement-of-url-length-limit-for-web-api-requests

Example of a GET request that utilizes a pre-configured filtered view by passing the view ID in the query parameters. This avoids long filterByFormula strings.

```curl
curl https://api.airtable.com/v0/BASE_ID/TABLE_ID_OR_NAME?view=Grid%20view \
  -H "Authorization: Bearer YOUR_API_KEY"
```

--------------------------------

### Creating a New Airtable Base via MCP

Source: https://support.airtable.com/docs/using-the-airtable-mcp-server

Use the `create_base` tool to create a new base, optionally defining tables and fields. Ensure you have Creator-level permissions and use `list_workspaces` to find the target workspace ID first.

```text
Use `list_workspaces` first to find the workspace ID where you want to create the base.
```

--------------------------------

### Blockquote Example

Source: https://support.airtable.com/docs/markdown-in-airtable

Use a greater-than symbol (>) at the start of a line to create a blockquote. This is not supported in base descriptions.

```markdown
> Roses are red
> Violets are blue
```

--------------------------------

### SWITCH() Example: Project Phase Determination

Source: https://support.airtable.com/docs/an-alternative-to-if-statements-using-switch

Demonstrates how to use SWITCH() to determine a project phase based on the 'Weeks Until Deadline' field. This approach is cleaner than nested IF() statements.

```Airtable Formula
SWITCH(
 {Weeks Until Deadline},
   4, 'Planning',
   3, 'Execution',
   2, 'Loose ends and review',
   1, 'Launch',
     'Out of range'
)
```

--------------------------------

### Get Week Number of the Year

Source: https://support.airtable.com/docs/formula-field-reference

WEEKNUM returns the week number within a year. Optionally, specify 'Sunday' or 'Monday' to set the start of the week.

```Airtable Formula
WEEKNUM("02/17/2013")
```

```Airtable Formula
WEEKNUM(TODAY(), "Monday")
```

--------------------------------

### Get Day of the Week

Source: https://support.airtable.com/docs/formula-field-reference

WEEKDAY returns an integer (0-6) representing the day of the week. Optionally, specify 'Sunday' or 'Monday' to set the start of the week.

```Airtable Formula
WEEKDAY("2021-06-09")
```

```Airtable Formula
WEEKDAY(TODAY(), "Monday")
```

--------------------------------

### Install Airtable Plugin for Codex

Source: https://support.airtable.com/docs/using-the-airtable-mcp-server

Use this command to install the Airtable plugin for Codex from your terminal.

```bash
codex plugin add airtable@openai-curated
```

--------------------------------

### Simple Growth Rate Calculation

Source: https://support.airtable.com/docs/conditional-formulas-with-emoji

This example demonstrates correct parentheses placement for a simple arithmetic calculation involving field references.

```Airtable Formula
({Present} - {Past}) / {Past}
```

--------------------------------

### Custom Instructions for Web Prototype Field Agent

Source: https://support.airtable.com/docs/ai-field-agent-build-prototype

Provides example custom instructions for an AI field agent designed to create web prototypes. It outlines the persona, task, and output format required for generating interactive prototypes from project specifications.

```plaintext
You are a skilled web developer and UX/UI designer with experience turning product specifications into interactive, visually appealing web prototypes. 
Assume the role of an expert focused on efficiently translating complex requirements into clickable, usable web app prototypes with strong attention to user flows and feature requirements. 
Maintain a professional and constructive tone suitable for technical product teams.

Task description:
Review the project information provided and use it to design and build a complete, interactive web application prototype. 
Interpret all available details, including descriptions, required features, user flow, and any wireframes or notes, to accurately reflect the intended user experience. 
Ensure the app includes all listed core features and follows the described flow. 
If visual cues or layout guidelines are provided, incorporate them as closely as possible. 
If any field is missing or lacks detail, fill in with logical, best-practice defaults consistent with modern web application standards.

Output format:
Generate a fully functional, interactive web prototype appropriate for the given specifications. 
The prototype must be clickable and allow users to explore main tasks and flows. 
Do not include explanations, links, summaries, or additional text—output the prototype only. 
If unable to generate a prototype due to insufficient information, output "Unable to generate prototype: missing or insufficient project details."

Example output: (The output is an interactive web prototype that opens in a browser and matches all provided requirements. No accompanying text is shown.)

Context and Data:
Description: {Insert "Description" field token}
Required Features: {Insert "Required Features" field token}
User Flow: {Insert "User Flow" field token}
Wireframe Sketch/Notes: {Insert "Wireframe Sketch/Notes" field token}

Output:
```

--------------------------------

### Example Base ID in Admin Panel

Source: https://support.airtable.com/docs/finding-airtable-ids

An example of a base ID as displayed in the Airtable admin panel.

```text
appogqUnF7gZJmeOv
```