> For the complete documentation index, see [llms.txt](https://docs.sheet.link/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sheet.link/formulas/apps/airtable.md).

# Airtable

Use the Airtable API to create, read, update, and destroy records in your Airtable Base.

Review the official[ Airtable API Documentation](https://airtable.com/api) 📖

{% hint style="info" %}
Note that ["options"](/formulas/options.md) are optional, other variables are required 👍
{% endhint %}

| Formula                                                                                                                                                                                                                                                                                                  |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><strong>=Airtable(</strong> <a href="/formulas/options.md"><strong>"options"</strong></a><strong>)</strong></p><p>Interact with the <a href="https://airtable.com">Airtable</a> API using only the SheetLink <a href="/formulas/options.md">"options"</a></p>                                         |
| <p><strong>=Airtable\_GetAll("base\_id" ,"table\_name" ,</strong><a href="/formulas/options.md"><strong>"options"</strong></a><strong>)</strong></p><p>Retrieve all existing records in a defined table.</p>                                                                                             |
| <p><strong>=Airtable\_Get( "base\_id" ,"table\_name", "record\_id" ,</strong><a href="/formulas/options.md"><strong>"options"</strong></a><strong>)</strong></p><p>Retrieve an existing record in a defined table.</p>                                                                                   |
| <p><strong>=Airtable\_Delete( "base\_id" ,"table\_name", "record\_id" ,</strong><a href="/formulas/options.md"><strong>"options"</strong></a><strong>)</strong></p><p>Delete an existing record in a defined table.</p>                                                                                  |
| <p><strong>=Airtable\_Update( "base\_id" ,"table\_name", "record" ,</strong><a href="/formulas/options.md"><strong>"options"</strong></a><strong>)</strong></p><p>Update an existing record in a defined table. ("record" must be in JSON format and include the record\_id of the record to update)</p> |
| <p><strong>=Airtable\_Create( "base\_id" ,"table\_name", "record" ,</strong><a href="/formulas/options.md"><strong>"options"</strong></a><strong>)</strong></p><p>Create a new record in a defined table. ("record" must be in JSON format)</p>                                                          |

{% hint style="success" %}
Missing a formula? [Suggest one here](https://www.sheet.link/suggest) 💡
{% endhint %}

### Navigation <a href="#where-to" id="where-to"></a>

| Page                                                                                                                                                      |
| --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p>🚀 <a href="/quickstart.md"><strong>Quick Start</strong></a>​</p><p>60 second getting started guide.</p>                                               |
| <p><strong>​</strong><a href="/faq.md"><strong>❓ FAQ</strong></a><strong>​</strong></p><p>Answers to frequently asked SheetLink questions.</p>            |
| <p>🛠️ <a href="/formulas/functions.md"><strong>Functions</strong></a><strong>​</strong></p><p>Powerful functions unique to SheetLink.</p>                |
| <p>💪 <a href="/formulas/options.md"><strong>"options"</strong></a><strong>​</strong></p><p>Control the request to and response from any application.</p> |

## 🚑 Need Help?

You can always contact us via <support@sheet.link> or by messaging us on Twitter [@SheetLink](https://twitter.com/SheetLink)
