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

# Update existing Airtable records with a form

> Make a form that edits existing records from Airtable and pre-fills fields with data from the record.

## Tutorial video

Check out [Gareth](https://www.garethpronovost.com/)’s tutorial on using Fillout to update existing Airtable records.

<iframe width="720" height="420" src="https://www.youtube.com/embed/mvDQBif-sbE" title="Updating Airtable records with advanced Fillout forms" frameborder="0" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen />

## How it works

<Warning>
  **Only share each update link with people who should see all of that record's fields.** An update link acts as a key to the entire record: anyone who opens it can view every field on the record, even fields that don't appear as questions on the form. This is what lets update forms use any record field for pre-filling, [answer piping](/answer-piping), show/hide [logic](/conditional-hiding), and [calculations](/calculations).

  To keep certain fields private, store them in a separate table so they aren't part of the record being updated, or [restrict prefilled data](/update-forms#restrict-prefilled-data) so the form only loads fields mapped to questions.
</Warning>

<Steps>
  <Step title="Switch to update mode">
    Open your [Airtable-connected form](https://www.fillout.com/help/airtable). Click `Integrate` on the top menu followed by `Airtable`.

    <img src="https://mintcdn.com/fillout-005a867b/aLRDfdVEIKVD8Ybq/images/Screenshot2025-11-10at10.47.05AM.png?fit=max&auto=format&n=aLRDfdVEIKVD8Ybq&q=85&s=2b40732511d24a7b1959648a27b07ac3" alt="Screenshot 2025-11-10 at 10.47.05 AM.png" width="2614" height="1437" data-path="images/Screenshot2025-11-10at10.47.05AM.png" />

    Then specify that you want to `Update record`.

    <img src="https://mintcdn.com/fillout-005a867b/bW6_fNNhlKgQzJGh/images/Screenshot2025-11-12at2.16.03PM.png?fit=max&auto=format&n=bW6_fNNhlKgQzJGh&q=85&s=1b674fcb169e721cbdf9100dfbd67303" alt="Screenshot 2025-11-12 at 2.16.03 PM.png" width="1684" height="678" data-path="images/Screenshot2025-11-12at2.16.03PM.png" />

    You’ll now get a formula that defines a **unique link** for every record in your table.
  </Step>

  <Step title="Paste the provided formula">
    Create a new `formula` field and copy the formula Fillout provides on the `Integrate` page.

    <img src="https://mintcdn.com/fillout-005a867b/Bc-CfW1Edpr3p-LV/images/uat2.png?fit=max&auto=format&n=Bc-CfW1Edpr3p-LV&q=85&s=6509493f976d66e8805f09846f1ac1a6" alt="Screenshot of the Form designer tab of a form" style={{ width:"67%" }} width="815" height="699" data-path="images/uat2.png" />
  </Step>

  <Step title="Publish and share">
    That's it! Click `Update` followed by `Publish` in the upper right corner.

    To update a record, click `Preview` and select a **Record to update** or click one of the unique links from your Airtable.

    <img src="https://mintcdn.com/fillout-005a867b/aLRDfdVEIKVD8Ybq/images/Screenshot2025-11-10at10.55.06AM.png?fit=max&auto=format&n=aLRDfdVEIKVD8Ybq&q=85&s=8c012cad88087a6c58804dcaf4749642" alt="Screenshot 2025-11-10 at 10.55.06 AM.png" width="2614" height="1445" data-path="images/Screenshot2025-11-10at10.55.06AM.png" />

    Your form is **automatically pre-filled** for whichever record it is updating.

    <Note>
      If you don’t provide an **id** in the unique URL, the form will create a new record instead.
    </Note>
  </Step>
</Steps>

## Let respondents choose a record to update

Use [this approach](/choose-record-to-update) if you prefer to let respondents choose (in Fillout) which record they’d like to update.

## Advanced next steps (Optional)

You can use update forms in combination with products like Airtable interfaces, Softr, or Stacker. For example, instead of adding a formula in Step 2 above, we could add a `Button` field.

<img src="https://mintcdn.com/fillout-005a867b/Bc-CfW1Edpr3p-LV/images/uat4.png?fit=max&auto=format&n=Bc-CfW1Edpr3p-LV&q=85&s=e63803a77c540d4764369a00b2a8376d" alt="Screenshot of the Form designer tab of a form" style={{ width:"63%" }} width="848" height="894" data-path="images/uat4.png" />

Then, we can display this button in an Airtable interface, for users to easily edit the record.

<img src="https://mintcdn.com/fillout-005a867b/Bc-CfW1Edpr3p-LV/images/uat5.png?fit=max&auto=format&n=Bc-CfW1Edpr3p-LV&q=85&s=0e38830366b38ef9bd9f9c992800afb8" alt="Screenshot of the Form designer tab of a form" width="2273" height="1336" data-path="images/uat5.png" />

## Airtable specific guides

<CardGroup cols={3}>
  <Card title="Create new linked records" icon="files-medical" iconType="regular" color="#FFC738" href="/create-new-linked-records">
    Let respondents create records from your form.
  </Card>

  <Card title="Choose a record to update" icon="files" iconType="regular" color="#FFC738" href="/choose-record-to-update">
    Let respondents choose from your form.
  </Card>

  <Card title="Create multiple records" icon="cabinet-filing" iconType="regular" color="#FFC738" href="/create-multiple-records-with-form">
    Add entries across multiple tables.
  </Card>
</CardGroup>
