Help

Copy Attachments from one table to another

Solved
Jump to Solution
360 2
cancel
Showing results for 
Search instead for 
Did you mean: 
cshenoy86
7 - App Architect
7 - App Architect

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!

 

 

cshenoy
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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.

Thank you for the solution! This works 🙂

cshenoy