Copy Attachments from one table to another

[cshenoy86]

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!

[Sho · Accepted solution]

This is possible with automation if Table2 has a value that identifies Table1.

If you only need to do it once, link Table1 to Table2 by company name, LOOKUP the attachment, and then copy the file by converting the Lookup field to the Attachment field.

This avoids consuming a large amount of Automation on the first run.

[cshenoy86]

Thank you for the solution! This works 🙂