Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Search Linked Field other than on primary key

Solved
Jump to Solution
789 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a table with a linked field to another table.

The linked field refers back to the primary key of the table I am linking back to (eg a unique project number) but that is just numbers and it doesn’t mean anything to most users when searching.

Is there any way I can have the linked field search for the name of the project rather than typing in the unique primary key to the record I want to link back to?

I have added a lookup field but this only pulls in the project name field once I have linked back using the link field by entering the corresponding unique job number,

1 Solution

Accepted Solutions

It might help to make the Primary field a formula field.

Move your Unique Project Number to a non-primary field. In the Primary field formula, CONCATENATE the Unique Project Number and the Project Field.

You can then search by name.

It’s what I did in this use-case.

I have a Proposals table. It is linked to a Foundations table. The Primary field is a formula field that combines a Date field and the Foundation name. Now, if I’m in the Foundation table, I can search a Proposal by name.

2021-10-21_14h59_35

2021-10-21_14h55_13

2021-10-21_14h55_21

On2Air Amplify can also help with this if you don’t want to change your field type. It has enhanced Search features and filtering.

image

See Solution in Thread

4 Replies 4

It might help to make the Primary field a formula field.

Move your Unique Project Number to a non-primary field. In the Primary field formula, CONCATENATE the Unique Project Number and the Project Field.

You can then search by name.

It’s what I did in this use-case.

I have a Proposals table. It is linked to a Foundations table. The Primary field is a formula field that combines a Date field and the Foundation name. Now, if I’m in the Foundation table, I can search a Proposal by name.

2021-10-21_14h59_35

2021-10-21_14h55_13

2021-10-21_14h55_21

On2Air Amplify can also help with this if you don’t want to change your field type. It has enhanced Search features and filtering.

image

Thanks for the quick reply and the detailed explanation. This has worked perfectly.
I will also look to give the On2Air a try too.
Thanks again
Karl

Thank you for suggestion. Wish Airtable has better plan for this.

While the suggestion to concatenate the primary field certainly helps, it becomes a messy solution if the search field is long text or if I want to search more than one field for an expression.  I have 1000's of fields on my database and lots of dependancies of the primary field. If I make the changes, I have to move out the field and create new concatenated field, it will take me several hours to complete it because I have so many dependancies with the primary field.