Skip to main content

​
What the record picker does

The record picker is the default interface for linked record fields. Respondents type a search query and see a list of matching records from the linked Airtable table. They click a record to select it and link it to the current submission.

​
How search works

The picker searches the primary field of the linked table as the respondent types. Results update with each keystroke. The respondent can select one or more records depending on whether the Airtable field allows multiple links. Selected records appear as tags below the search input. The respondent can remove a selected record by clicking the X on its tag.

​
Filtering which records appear

You can restrict which records appear in the picker using the Always filter by setting on the linked record field. This is a permanent filter. Records that don’t match the filter never appear as options. Example: On an order form, you might have a “Products” linked field. If you only want to show active products, add a filter: Status is Active. See Filtering records for detailed configuration.

​
Creating new records from the picker

If Enable creating is turned on, a “Create new” button appears in the picker. The respondent clicks it and a child form opens where they can fill in details for a new record. That new record is automatically linked to the current submission. See Child forms for how to set this up.

​
Count limits

You can require a minimum number of linked records, enforce a maximum, or both. The picker shows an error if the respondent tries to submit with too few or too many records selected. See Count limits for configuration details.

​
Common questions

The primary field of the linked table. This is the first field in the table, the one shown in bold in Airtable’s grid view. You control which field is primary in Airtable.
The picker loads records in pages as the respondent types. It does not load all records upfront. Search queries are sent to Airtable in real time.
The single vs multiple selection behavior is controlled by the Airtable field type. If the Airtable field is a single-record link field, the picker only allows one selection.
The picker shows the primary field by default. Additional field values are not displayed in the picker results currently.