Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to automate entries between two tables

1380 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Will_Goldstone
4 - Data Explorer
4 - Data Explorer

Hi there, i’m pretty new so excuse me posting in the main channel instead of directly in Formulas forum - i’m not sure if its the answer to my question - I’ll get to the point!

I have two tables - one is called Games, and another Genres.

In Games, I have a name and a genre of the game.

In Genres I have a list of Genres - naturally! for each row I would like to find a list of all games in Games, and populate where the genres match. eg. In Genres, for my First Person Shooter row, in a new column called games i’d like to list all the games in my games table where I’ve already specified first person shooter - by automatically saying 'if the Name field in this table (genre) matches the genre field in this other table (Games).

How do I best approach that? is it a formula? or something else? thanks for your patience with this n00b question!

2 Replies 2

Hi @Will_Goldstone - Airtable will do this for you automatically. If you create a link field in your games table to genres you’ll this:

Screenshot 2019-05-20 at 15.09.39.png

Back in the genres table you’ll see this:

Screenshot 2019-05-20 at 15.10.11.png

Is this what you want to see?

JB

Hey JB, I’m total fool. I’d already done that but hidden the field by mistake and started working on another one - thanks so much!