> ## Documentation Index
> Fetch the complete documentation index at: https://fillout-005a867b-dependabot-npm-and-yarn-form-data-4-0-6.mintlify.site/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

<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-dependabot-npm-and-yarn-form-data-4-0-6/n9ebohD05VHZJ-H5/images/Screenshot2025-11-10at10.47.05AM.png?fit=max&auto=format&n=n9ebohD05VHZJ-H5&q=85&s=c40d516ed01e24c7f4b73bc0823eb35b" 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-dependabot-npm-and-yarn-form-data-4-0-6/n9ebohD05VHZJ-H5/images/Screenshot2025-11-12at2.16.03PM.png?fit=max&auto=format&n=n9ebohD05VHZJ-H5&q=85&s=d68e5d72e8d6f89227e8f3d5c264a230" 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-dependabot-npm-and-yarn-form-data-4-0-6/u2EZ6ISDg1R6HSZi/images/uat2.png?fit=max&auto=format&n=u2EZ6ISDg1R6HSZi&q=85&s=17b19a99384cd1e83f007ea37efd9881" 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-dependabot-npm-and-yarn-form-data-4-0-6/n9ebohD05VHZJ-H5/images/Screenshot2025-11-10at10.55.06AM.png?fit=max&auto=format&n=n9ebohD05VHZJ-H5&q=85&s=5652e8e52e5beb8ef779dbd339f67c2f" 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-dependabot-npm-and-yarn-form-data-4-0-6/u2EZ6ISDg1R6HSZi/images/uat4.png?fit=max&auto=format&n=u2EZ6ISDg1R6HSZi&q=85&s=b1e36db30a54b55df32532bb7cacbaca" 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-dependabot-npm-and-yarn-form-data-4-0-6/u2EZ6ISDg1R6HSZi/images/uat5.png?fit=max&auto=format&n=u2EZ6ISDg1R6HSZi&q=85&s=9d00fb7d0441f9b4a878dfeb2106c6fb" 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>
