Airtable lookup is empty: trace the link before the formula

SOURCE-BASED ANALYSIS · NO HANDS-ON RATING

Start with one failing record

An Airtable lookup reads a selected field through a linked record relationship. Creating the field definitions is insufficient: the actual rows must be connected. A blank result can therefore be a relationship problem rather than a formula problem. Choose one failing record and a known-good record before changing the schema.

Illustrative support ticket

Ticket T-42 should display a customer’s support address. The Customers table contains the address, but the ticket’s Customer link is empty. Typing the customer name in a separate text field does not establish the intended relationship. Compare T-42 with T-41, which has both a populated Customer link and the expected lookup result.

Trace in a fixed order

1. Open T-42 and inspect the exact linked record field selected in the lookup configuration.
2. Follow that relationship to the actual customer record, checking its identifier rather than relying on a similar display name.
3. Inspect the source address field on that customer.
4. Check whether lookup conditions exclude the record.
5. Connect a disposable test ticket to the known-good customer and compare the result before altering any formula.

Distinguish blank from multiple values

If two customer records are linked, decide whether the ticket genuinely allows multiple customers. Do not conceal the ambiguity by joining the addresses into text and treating the result as a single validated destination. A display problem and a recipient-selection policy require different fixes. Write down which customer owns the ticket and repair the relationship or process accordingly.

Prevent the next failure

For a proposed intake process, include the linked customer in the readiness check before downstream work begins. Keep an exception queue for missing links and missing source addresses. Recheck one failing example after the repair and also verify a known-good record, so that a broad configuration change does not silently exclude valid customers. This guide supplies a diagnostic procedure, not evidence that a particular base has been tested.

Continue with Airtable linked record pickers: view filters are not validation when that next step matches your workflow.