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=1c708dfb92651fb230f375f758d4d172ad56602b0347fccf8ac86f495d5a8522 , 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.