Skip to main content

Problem:
When adding a linked record in Airtable, the search is currently limited to the Primary Field of the linked table. In many cases, however, the Primary Field is a technical ID or a customer number, which is neither intuitive nor easy to remember for users.

Example:
We have a customer table with fields like Customer Number, Company Name, and Address. When linking a customer to a product table, we can only search by the Customer Number (Primary Field). This is inconvenient because we would often prefer to search or filter by Company Name or Address to quickly find the correct customer.

Current Workarounds:

  • It’s possible to create a formula field that combines multiple fields (e.g., Customer Number + Company Name).

  • However, this combined field would need to become the Primary Field, which is often not allowed or desirable, as the Primary Field must not be changed (e.g., in synced tables or when data is externally managed).

  • Another potential idea would be to use Lookup Fields, which display information from linked records. Unfortunately, it is not possible to link or search directly through Lookup Fields, which would otherwise be an ideal solution for this scenario.

Proposed Solution:

  1. Allow users to define which fields are searchable when linking records.

    • For example, users could configure a linked field to search by Company Name or Address in addition to the Primary Field.

  2. Enable linking through Lookup Fields.

    • If Lookup Fields could act as searchable and selectable fields when creating links, it would add a lot of flexibility and solve the limitation of being restricted to the Primary Field.

Use Case Example:
Instead of only typing 12345 (Customer Number) into the search box, we could also type “Musterfirma GmbH” or “Musterstraße 5” to find the correct customer record.

Yes, this has been a longstanding customer request going back many years.

If you’d like to get this functionality in a form, Fillout’s Airtable forms offer this functionality. Fillout is 100% free and it even offers the ability to update existing Airtable records with a form.

See screenshot below.

Otherwise, Airtable doesn’t read our messages here, so be sure to:

  1. Email your feedback to support@airtable.com
  2. Fill out this form with your feedback.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with anything that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

 


Thank you for your response! I understand that third-party solutions like Fillout might offer this functionality, but for us, using an additional tool is not an option. Also, assigning records via a form is too cumbersome for our workflows.

What we really need is a native Airtable feature that allows searching across multiple fields (or even via lookup fields) directly within the link dialog — without having to change the primary field or rely on external tools. This would be a huge improvement and is something we’d love Airtable to integrate directly.

I will make sure to share this feedback with Airtable via email and their form as you suggested. Hopefully, this long-requested feature will be considered soon!


Reply