I have two tables: Table 1 with companies and their data and table 2 which is synced from box that has the details on company logos as png images for each company.
I have managed to use airtable sync to pull in the logo images from box to airtable - table 2. However now I want to copy those images to table 1 that has company data. Basically the idea is to match the company names between table 1 and table 2 and then copy images from table 2 to table 1 if there is a match.
Is there a way to automate this?
If I had to make use of lookup fields, how should I go about it?
Thanks!