Lookup Fields - search non-primary field?

[AdamHassig]

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?

[TheTimeSavingCo · Accepted solution]

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}

[ScottWorld]

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