Forms - Lookup search on multiple fields


Is it possible to search on multiple fields when filling in a lookup on a form?

For example, if I have a lookup in a form to a base containing user details, I would like to search for their phone number, name or user id.

Unfortunately, Airtable form fields can’t be used to search across multiple table fields. Each field in a form ties to a specific field in the table where it lives. To do what you want, you’ll need to enlist the help of a more robust form system, or code a custom form that searches behind the scenes using the Airtable API. I don’t have direct experience with the latter, and only marginal experience with other form systems, but nothing tied to your use case. Here’s hoping some others will chime in with info that could help you.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.