> ## 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.

# Choose a record to update

> Let users choose the record they want to update in Fillout and update it with a custom form.

## Overview

Fillout lets you [create update forms](/help/airtable-update-form) to update existing records in Airtable, SmartSuite, Notion and other databases. By default, however, Fillout requires you to pass in the record ID to update in the URL. With the approach described below, you can have your users `choose which record they would like to update`.

<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](/help/answer-piping), show/hide [logic](/help/conditional-hiding), and [calculations](/help/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](/help/update-forms#restrict-prefilled-data) so the form only loads fields mapped to questions.
</Warning>

## How it works

<Steps>
  <Step title="Create an “update” form">
    Follow the steps [here](/help/airtable-update-form) to create an “update” form. Make sure to select `Update record` on the integration and to publish the form.

    <Frame style={{ width: '624px', height: '133px' }}>
      <img src="https://mintcdn.com/fillout-005a867b/S51fcTwdhWah2VpJ/images/Screenshot2025-05-16at3.14.57PM.png?fit=max&auto=format&n=S51fcTwdhWah2VpJ&q=85&s=aad2c4a97335b3ae28377312ee3caeb2" alt="Screenshot of the Form designer tab of a form" width="2558" height="542" data-path="images/Screenshot2025-05-16at3.14.57PM.png" />
    </Frame>
  </Step>

  <Step title="Create another form to choose the record">
    Create another form. This is the main form you will send your respondents to so that they can choose the record to update.

    In the form, add a linked record picker that links to the Airtable you would like to update. For example, if your first form updates a Product Inventory table, create this form tied to a different table that has a linked relation with Product Inventory. In this form, add a record picker to choose from those products:

    <Frame style={{ width: '528px', height: '195px' }}>
      <img src="https://mintcdn.com/fillout-005a867b/S51fcTwdhWah2VpJ/images/Screenshot2025-05-16at3.15.06PM.png?fit=max&auto=format&n=S51fcTwdhWah2VpJ&q=85&s=2eedbe74987a3913784bbcc161f63917" alt="Screenshot of the Form designer tab of a form" width="2556" height="942" data-path="images/Screenshot2025-05-16at3.15.06PM.png" />
    </Frame>
  </Step>

  <Step title="Connect the forms together">
    Navigate to the [ending page](/help/ending-page) of your record chooser form and set your update form as the **New form to redirect to**.

    <Frame>
      <img src="https://mintcdn.com/fillout-005a867b/S51fcTwdhWah2VpJ/images/Screenshot2025-05-16at3.15.30PM.png?fit=max&auto=format&n=S51fcTwdhWah2VpJ&q=85&s=2f407b0267bb64a60a3870a9f2f1d4d8" alt="Screenshot of the Form designer tab of a form" width="1822" height="1300" data-path="images/Screenshot2025-05-16at3.15.30PM.png" />
    </Frame>

    Finally, pass the record ID to update the update form. Click `Set URL parameters` to choose the `ID` parameter of your update form and map it to your record picker field’s `Record ID`.

    <Frame style={{ width: '480px', height: '302px' }}>
      <img src="https://mintcdn.com/fillout-005a867b/S51fcTwdhWah2VpJ/images/Screenshot2025-05-16at3.15.39PM.png?fit=max&auto=format&n=S51fcTwdhWah2VpJ&q=85&s=64d84545b3fa4a9ec6d891f14a8fb1f7" alt="Screenshot of the Form designer tab of a form" width="2062" height="1298" data-path="images/Screenshot2025-05-16at3.15.39PM.png" />
    </Frame>

    <Tip>
      **Tip:** If you don’t want to create records in your first form, you can always [set a condition](/help/conditional-integration) for when the integration is run (set a condition that is never true).
    </Tip>

    That’s it! You can now send respondents to your picker form to choose a record. Once they submit that form, they’ll be automatically redirected to the update form, which will be pre-filled with the record they chose.
  </Step>
</Steps>

## Airtable specific guides

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

  <Card title="Select Airtable records in a dropdown" icon="square-caret-down" iconType="regular" color="#FFC738" href="/help/select-linked-airtable-records">
    Make a linked record picker in Fillout and filter records.
  </Card>

  <Card title="Create multiple records" icon="cabinet-filing" iconType="regular" color="#FFC738" href="/help/create-multiple-records-with-form">
    Make a Fillout form that creates multiple Airtable records in different tables.
  </Card>
</CardGroup>
