Help

Search Linked Field other than on primary key

Solved
Jump to Solution
1093 4
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 - Apps for Airtable - Dashboards, Forms, Backups, and Documents

See Solution in Thread

4 Replies 4
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 - Apps for Airtable - Dashboards, Forms, Backups, and Documents
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 - Apps for Airtable - Dashboards, Forms, Backups, and Documents

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.