Help

Search Linked Field other than on primary key

Solved
Jump to Solution
3735 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Karl_Olney
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Hannah_Wiginton
10 - Mercury
10 - Mercury

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

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

See Solution in Thread

6 Replies 6
Hannah_Wiginton
10 - Mercury
10 - Mercury

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

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable
Karl_Olney
5 - Automation Enthusiast
5 - Automation Enthusiast

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

You bet! Hope it helps!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

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. 

 

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.

This is an external form outside of Airtable so may not work exactly the way the OP wanted.

Can you explain more? How do you see this as a solution?  

By the way, does it mean I design the Fillout form and that allows me to search any field that is in the table and select that record? Does it pre-fill the remaining fields based on what is already filled in Airtable? I thought forms can only create or update records but not view existing records e.g. calculated values.