Matching data from 2 different tables

551 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there

I have an Airtable base with 2 tabs: 

1. Resellers: on which I keep the "Company" name and the "Website" of resellers I'm working with. Company and Website are my 2 fields on this tab

2. Performance: on which I have some datas imported from a Google Sheet. Here I have 3 tabs : email_domain, total_mrr and total_projects

I would like to add a field "Results" to my Resellers tab on which I automatically render the total_projects from the table Performance for each of my resellers. The issue here is that the performance table is randomly ordered so there is a need to make a match between the Website from Resellers and the email_domain from Performance and to render the good value for each Reseller. 

I tried to set up an Automation or even find a way to do it through Make but I didn't manage to achieve that so far. I'm wondering if it's possible to make 2 cells from 2 different tables match to each others. 

1 Reply 1
11 - Venus
11 - Venus

Hi @Thibogrn,

If Website = Email domain, how about converting Website to a "link to other tables" field?