How to Auto-Fill Fields From a Linked Record in Airtable

Imagine a lab with an Item Master table containing every approved item it can order. Each item has a part number, description, vendor, and unit cost.

Employees submit requests in a separate Item Requests table. When a request matches an approved item, you want Airtable to show those details without copying them into the request.

The Airtable setup is a linked record plus lookup fields. If employees type the part number into a free-text request field, an automation can find the exact match and create the link for them.

The same setup works for a registry. Someone selects an approved record, and Airtable shows the related details in the new record.

An Airtable item master record linked to a request with item details filled in

Create the item tables

In Item Master, make Part Number the primary field. Add Description, Vendor, and Unit Cost fields. If only some items should be available in the form, add an Active checkbox too.

Create an Active items view in Item Master and filter it to records where Active is checked. This view will control which items people can select in the form.

In Item Requests, add these fields:

FieldTypeWhat it does
Requested itemLong textWhat the employee types, such as ABC-100G or 100 gram tubes
Matched itemLink to another recordConnects the request to Item Master
Catalog descriptionLookupShows the matched item’s description
Catalog vendorLookupShows the matched item’s vendor
Catalog unit costLookupShows the matched item’s current cost

When you create each lookup field, choose Matched item as the linked record field and select the matching field from Item Master.

The lookup fields stay empty until Matched item contains a real link. Creating the linked field alone does not connect any records.

For the general linked-record and lookup pattern, see how to reference data across Airtable tables.

Let the employee choose an approved item

If every request must use an item that already exists in Item Master, add Matched item to the Airtable form. In the field settings, turn on Limit record selection to a view and choose Active items. Employees will then choose from the approved items instead of searching the full master list. If the choices need to depend on another answer in the form, see how to limit linked-record choices based on another field.

After the form is submitted, the Catalog description, Catalog vendor, and Catalog unit cost fields show the values from the selected item. Lookup fields do not fill other fields while someone is still completing the form because the record does not exist until submission.

This is the simplest option because the employee creates the link while submitting the request. You do not need an automation.

For more examples of showing information from related tables, see how to display related data from multiple Airtable tables.

Copy the details into editable fields

Lookup fields always show the current values from Item Master. If the fields in Item Requests must remain editable, keep regular fields such as Description, Vendor, and Unit Cost alongside the catalog lookup fields.

Add those regular Description, Vendor, and Unit Cost fields to Item Requests if they are not there already.

Create one automation that runs when Matched item is not empty. Add an Update record action for the request and map Catalog description, Catalog vendor, and Catalog unit cost into the matching regular fields.

This works for every selected item, so you do not need a separate automation for each item or organization. Only copy the fields that should come from Item Master. Leave any fields that people must enter or change themselves out of the automation.

If the request only needs to display the current catalog values, keep the lookup fields and skip this automation. See how to show data from one Airtable table in another without automations.

When users need to type instead of choosing

If people need to enter a part number or describe an item that is not in the approved list, do not make them choose from Matched item. Keep their answer in Requested item, then let an automation link only the requests that contain an exact approved part number.

Create an automation with the When record matches conditions trigger in Item Requests. Set it to run when Requested item is not empty and Matched item is empty.

Add a Find records action that searches Item Master where Part Number equals Requested item from the request.

Then add an Update record action:

  1. Choose Item Requests as the table.
  2. Insert the triggering request’s Record ID.
  3. Choose Matched item as the field to update.
  4. Insert the matching Item Master record’s Airtable record ID from the Find records step.

After Airtable creates the link, the Catalog description, Catalog vendor, and Catalog unit cost lookup fields fill in. This is the same find-and-link pattern used in how to automatically link records between Airtable tables.

Review requests without a match

The automation only handles exact part-number matches. ABC100G will not match ABC-100G, and 100 gram tubes will not match either value.

Requests without a match stay unlinked, so someone can correct the part number, choose an approved item, or add a new item to Item Master. Keep part numbers unique because Airtable cannot choose between two master records with the same value.

If Part Number is a formula field, link the matching record using its record ID instead of trying to match the formula value in the automation.

Keep old request costs unchanged

The Catalog unit cost lookup always shows the current value in Item Master. If the cost changes, older requests show the new cost too.

That is useful when requests should always use the latest catalog information. If a purchase needs to keep the cost from the day it was approved, copy Catalog unit cost into the regular Unit Cost currency field at that point. See how to keep old sales records accurate when product prices change in Airtable.