- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2024 06:06 AM
Hello, I am trying to use a lookup field from another sheet. It seems that I can only search by the primary field, not by the field I have selected as the source. For example:
Sheet 1 - Primary field: Job #
Job #: 1234
Job Name:
Sheet 2
Lookup field in sheet 1 - Job Name: (I can search for Job # (1234), but not by job name.
Is there a way to fix this or work around?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2024 07:57 AM
There's only a workaround I'm afraid, and it's to make the primary field a formula field that combines the info that you want to search by. In your context, it would be something like
{Job #} & " - " & {Job Name}
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2024 07:57 AM
There's only a workaround I'm afraid, and it's to make the primary field a formula field that combines the info that you want to search by. In your context, it would be something like
{Job #} & " - " & {Job Name}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2024 08:55 AM
In addition to what Adam mentioned above, the only other workaround to this major problem is to use Fillout’s advanced forms for Airtable.
Fillout lets you update existing Airtable records from a form, and you can search by ANY field that you want.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
