Linking Records in Different Tables Automatically

I have a table with 350 records (projects) and another table with about 200 records (clients). Is there a way to link a record in the projects table to a field in the client table without having to individually link 350 records to a specific record in the client table? I am thinking something like a VLOOKUP command in Excel, or an IF command that returns a certain record. I just can’t see having to individually create a specific link for all 350 records. What am I missing?

Hey Steve - Yes there is. You can do this via the “Link to” feature in Airtable:

So let’s take this table with example data:

Here we have a list of clients, and we want to link them to projects - We do this via “Link to” field

Screenshot 2020-01-25 at 15.20.19

Like the above image. Now, in projects, we can see the projects broken out by the client

Screenshot 2020-01-25 at 15.20.47

Hope that helps!

Thank you for that. But don’t I still have to go into each of 350 records individually and create the link? I am trying to avoid that and have the column automatically link to another table based on some criteria in the table I am linking from.

Hey Steve,

When you change the field to a Link_To, providing the Field text is the same, Airtable will automatically link every field

But I still have to go to each cell and create the link to the correct record in the other table?

I have also used Smartsheet and it allows me to copy a formula down a column to do a VLOOKUP:

image

I’m assuming Field 12 is Project ID?

You shouldn’t have to be doing this at all - I’m not understanding where you’re blocked, if you already have a list of the Client IDs and Project IDs, you can paste those Field12s as a comma separated list?

Field 12 is the Client ID. I would love to just reference a Client ID in my project table, go out to look up that Client ID in my client table, and return an email, address, etc. The only way I see to do that is create Link column and then link a record but do that for each, individual record.

I am thinking I need to use Smartsheet for this since it has a Vlookup capability.

Initially, yes - You will need to use a vlookup to get the data into Airtable, but once that’s done, you should be able to automate the process with Zapier or Integromat

Hey @Steve_T - Try making the first field a formula, instead of the client ID - So it would be something like

{Client ID} & " - " & " {Client Name}

That way you can paste a list of client IDs, and it will do all the lookups for you automatically.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.