Skip to main content

I can’t figure out how to make links between two tables work the way I need them. Here’s the situation:

Table 1 contains a list of Companies. These Companies are differentiated by Type (multiselect) and split into multiple views based on that: Producers view and Architects view.

Table 2 contains a list of Projects. Each Project has a Project Owner field (link to Companies, single record) and Project Participants field (link to Companies, multiple records).

So far so good. Back to Table 1, for each Company I need it to show the following fields:

  • Projects (Participant) - Link to Projects and show all Projects where a Company is referenced as the Project Participant
  • Projects (Own) - Link to Projects and show all Projects where a Company is referenced as the Project Owner

This is where I get stuck: When creating a link to the Projects table (2) from the Companies Table (1), I’m only able to get the Projects (Particpant) field working, and have no way of differentiating the Project (Own) field from it. Is there a way to do this or am I somehow setting things up wrong?

Thanks!

After you create the linked record fields in Table 2, Airtable will automatically create the “backlink” fields for you in Table 1.

If you’re not seeing the backlink fields in Table 1, then check underneath the “hidden fields” button in the toolbar, and you can make them visible from there.

Unfortunately, one of the big problems with Airtable is that it doesn’t name your backlink fields very well… the backlink fields will simply be named with the name of Table 2. 

So you will need to manually rename the backlink fields to become something more descriptive & understandable, such as “Referenced As Project Participant For These Projects” and “Referenced As Project Owner For These Projects”.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with anything that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thank you Scott, that was fast and it helps :) I wasn’t aware of how the backlink fields work.

You’re welcome! Glad I could help! :)

- ScottWorld, Expert Airtable Consultant

Terms & Conditions