# Airtable

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

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

| Formula                                                                                                                                                                                                                                                                                        |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><strong>=Airtable(</strong> <a href="../options"><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="../options">"options"</a></p>                                                   |
| <p><strong>=Airtable\_GetAll("base\_id" ,"table\_name" ,</strong><a href="../options"><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="../options"><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="../options"><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="../options"><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="../options"><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"><strong>Quick Start</strong></a>​</p><p>60 second getting started guide.</p>                                    |
| <p><strong>​</strong><a href="../../faq"><strong>❓ FAQ</strong></a><strong>​</strong></p><p>Answers to frequently asked SheetLink questions.</p> |
| <p>🛠️ <a href="../functions"><strong>Functions</strong></a><strong>​</strong></p><p>Powerful functions unique to SheetLink.</p>                 |
| <p>💪 <a href="../options"><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)
