Oct 14, 2020 09:05 PM
When I’m searching for an existing record with a linked field, the search field only searches the primary field (in my case it is an autonumber).
Is there any way to search across other fields as well? For example I have another field that is a text field and contains the name of the request.
Solved! Go to Solution.
Oct 14, 2020 09:48 PM - edited Jul 29, 2023 12:50 AM
Unfortunately, no. You should definitely email support@airtable.com about this, but it won’t likely do any good because everybody has been requesting this for years, and Airtable has never implemented this.
In the meantime, the workaround is to create a formula field as your primary field that contains all the different fields that you would ever want to search on in the linked record field.
You can move your autonumber field to become another field, and that field can become a part of your new formula field.
Alternatively, for 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.
Oct 14, 2020 09:48 PM - edited Jul 29, 2023 12:50 AM
Unfortunately, no. You should definitely email support@airtable.com about this, but it won’t likely do any good because everybody has been requesting this for years, and Airtable has never implemented this.
In the meantime, the workaround is to create a formula field as your primary field that contains all the different fields that you would ever want to search on in the linked record field.
You can move your autonumber field to become another field, and that field can become a part of your new formula field.
Alternatively, for 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.
Oct 14, 2020 11:01 PM
Thanks @ScottWorld that makes sense to me
Jul 29, 2023 12:50 AM
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.