Search in all fields (link to record)

[Mohsen_khaldoun]

Hi everyone! I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table). I tried to do that but I get result only from the first field

[kuovonne]

The search box will only search the current table. It will not look into linked records.

To include fields from linked records in the current table, add lookup or rollup fields.

To search across multiple tables, you can also use the Search block.

[Justin_Barrett · Accepted solution]

When linking to records from another table, Airtable only lets you search based on what’s in the primary field in the target table. To find records using info from other fields, one possibility is to turn the primary field into a formula that concatenates data from several other fields. This isn’t ideal in all situations, but it’s the only way to currently do this with Airtable’s native features.

[ScottWorld]

There is now an external solution to this problem. You can now use Fillout, which lets you specify as many fields as you want that will be searchable in linked record fields.