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

# Select and filter Airtable linked records in a dropdown

> Let respondents select Airtable linked records from a Fillout form. Optionally filter records based on prior inputs.

## Video tutorial

In Fillout, you can even filter which records a respondent is choosing from. Here's how.

[Select & Filter Airtable Linked Records in a Dropdown](https://www.loom.com/embed/0b693e23011647ff880973b55489a16b)

## Enable dropdown filtering

**1. Create a linked record picker field**

On the Airtable base you plan to write or update, click **+** followed by **Link to another record**.

![Airtable field type menu with Link to another record at the top](https://mintcdn.com/fillout-005a867b/aqXKCqHt_hdWxyos/images/airtable-link-to-another-record.png?fit=max\&auto=format\&n=aqXKCqHt_hdWxyos\&q=85\&s=a3b79f1109d5eb25e2d5633629f3587e)

**2. Connect to Airtable**

Click **Integrate** on the top menu followed by **Airtable**. Then, choose your **base** and **table**.

**3. Add the field to your form**

On the left-hand panel, drag and drop the linked record picker field onto your form. You'll immediately be able to pick from records in that associated table.

![Products record picker on a form, open with linked Airtable records and their details](https://mintcdn.com/fillout-005a867b/aqXKCqHt_hdWxyos/images/airtable-linked-record-picker.png?fit=max\&auto=format\&n=aqXKCqHt_hdWxyos\&q=85\&s=dc0efdf04747069f7d74b64de691aac9)

**4. Add filters**

Click the field's **settings icon**  to open the right-hand panel. Scroll down to **Advanced** to **+ Add filters**.

![Record picker Advanced settings with the Add filters button highlighted](https://mintcdn.com/fillout-005a867b/aqXKCqHt_hdWxyos/images/airtable-record-picker-add-filters.png?fit=max\&auto=format\&n=aqXKCqHt_hdWxyos\&q=85\&s=ff0b6789a0da67c644dd81d9f7995cb7)

Each filter can use one of these operators:

* **equals**
* **does not equal**
* **equals (case non-sensitive)**
* **contains**
* **less than**
* **greater than**
* **is empty**
* **is not empty**

Number fields only offer **equals**, **does not equal**, **less than**, **greater than**, **is empty** and **is not empty**.

For example, on a form that [updates records](https://fillout.com/help/airtable-update-form.md), filter on a field that **is empty** to list only the records that still need filling in.

Filters are applied on the server, rather than relying on values supplied by the respondent's browser. **Require all filters**, at the bottom of the **Filter records** dialog, is off by default. Tick it to only show records once every filter can be applied:

* With it on, if a filter's value is empty, for example because it uses an answer the respondent hasn't given yet, the dropdown shows no records. This doesn't apply to **is empty** and **is not empty** filters, because they don't use a value.
* With it off, a filter whose value is empty is skipped, and the other filters still apply.

A filter whose value has more than one item, like the answers from a checkboxes question, matches no records. Use an answer with a single value instead.

**5. Publish and share**

**Publish** your form to make the changes reflect.

## Additional custom options

Now, you can customize this field with many options like:

* Allow respondents to create new entries in a new (customizable) form
* Allow selecting multiple linked records
* Select which fields to show (can show images!)
* Limit to a view
* Pick which field to search by
* Filter which records to show based on form inputs or dynamic data
* And more

## Related articles

> [card] [Create new linked records](https://fillout.com/help/create-new-linked-records.md)
>
> Let respondents create records from your form.

> [card] [Update Airtable records](https://fillout.com/help/airtable-update-form.md)
>
> Edit existing records and pre-fill fields.

> [card] [Working with linked record pickers](https://fillout.com/help/record-pickers.md)
>
> Set pre-fills, reference fields, and more.

Still have questions?

Our team is happy to help. Start a live chat using the

chat bubble  in the bottom right, or email us at

[support@fillout.com](mailto:support@fillout.com)

[Contact us](mailto:support@fillout.com)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.