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.
