Help

Need help in copying images from one table to another (using script)

Topic Labels: Scripting extentions
Solved
Jump to Solution
2798 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Agota_K
4 - Data Explorer
4 - Data Explorer

Hello!

My goal would be to automatically add photos from Table 2 (where they are imported in bulk) to Table 1 (with the right item order).
The only link between the items in the two tables is a code/name column.
I tried my best experimenting with formulas in Airtable and GSheet, but I couldn’t find any solution. I copied a script from an older community topic: Programmatically copy images from one table to another , but it doesn’t seem to work.

Can someone please help figure out what the problem might be, or offer another solution? Here’s a simple version of my base (Restaurant):
https://airtable.com/invite/l?inviteId=invyOwrzT6i00qbss&inviteToken=1c708dfb92651fb230f375f758d4d17... , where the pasta dishes (Menu Item Name) should get the photos in the Attachments column from the Image column in Table 2, connected by the Name and Code columns.

Thank you!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

I totally understand not wanting hours of repetitive work. However, converting a field to a linked record field and using lookups could be done in a couple of minutes with the base design you shared, even with hundreds of records. You can create a new linked record field and copy/paste the codes in one giant column copy/paste. Airtable will convert the text strings to links when you paste into the linked record field.

See Solution in Thread

5 Replies 5

Hi Agota, and welcome to the community!

This is a touchy aspect of the Airtable platform. The following thread (and example code) might help.

Welcome to the Airtable community!

Is there a particular reason why you want to copy the photos with a script?

Since the tables are in the same table, you could move the “code” in [Table 1] to a different field (not the primary field) and convert it to a linked record field. Then pull the image across using a lookup field.

FYI, the shared link in your post adds anyone who clicks on it as a creator in your workspace. It looks like the workspace has only one table and is on a pro trial, so you shouldn’t be charged (yet) when someone clicks on the link. However, you might want to edit your post to change the link to a read-only shared link to just the base. That way you won’t be charged and people won’t have creator access to other bases that you might create.

Thank you!

A script would probably be the best solution, because I would like to use it on tables with hundreds of items, where it would take a long time to drag and drop the photos into the right row.

Basically, I have a long list of items and a big batch of photos, and I would like to link them together without hours of repetitive manual work.

kuovonne
18 - Pluto
18 - Pluto

I totally understand not wanting hours of repetitive work. However, converting a field to a linked record field and using lookups could be done in a couple of minutes with the base design you shared, even with hundreds of records. You can create a new linked record field and copy/paste the codes in one giant column copy/paste. Airtable will convert the text strings to links when you paste into the linked record field.

When I was trying to find a solution with links and formulas, I somehow missed this. Thank you very much kuovonne!