Concatenate 2 Pictures field

[DanielAssayag]

Hi,
I have two fields containing image attachements.

I want to join them in one, but when i try to do this it is printed as text and url…

any ideas?

[Justin_Barrett]

Formulas can’t be used to combine the contents of multiple attachment fields. It may be possible to copy the attachments between fields with the help of Zapier or Integromat, but I’ve not done anything with either service involving attachments, so I couldn’t say for sure.

Is there a particular reason the attachments aren’t in a single field to begin with? Not trying to question your setup, just curious if there’s a way to optimize it so that attachments go directly into a single field instead of two.

[DanielAssayag]

I’m not copying data because users are sending data with forms.
I’m creating a database of projects, each user can update activity on their project by either creating a journal entry, of a reservation (for a machine). Journal/ Reservation forms have both a picture field (attachement field) and i wish to combine them in one field when i present the content of the project.

Airtable

Projects@Makerlab - Airtable

Explore the "Projects@Makerlab" view on Airtable.

[Justin_Barrett]

Gotcha. Because you’ve been trying to copy between two attachment fields, it sounds like both forms are already coming from the same table. In that case, one way to address that is to have both forms use the same attachment field, rather than a separate attachment field for each form. That way one field has all pictures for both journal entries and reservations.

[DanielAssayag]

The two forms are separated and i retrieve the pictures from the forms of other tables.

[Justin_Barrett]

In that case you’ll probably need to use an external service like Zapier or Integromat to do the copying. I just ran a test in Integromat copying an attachment between two different bases, and it worked fine. You could probably set up a scenario that runs daily and copies any uncopied images.

[Eduardo_Pimente]

Hi @Justin_Barrett!

Justin_Barrett:

I just ran a test in Integromat copying an attachment between two different bases, and it worked fine.

Could you make concatenating two images fields into another? If yes, would you mind sharing how using Integromat?

Thanks!

[Justin_Barrett]

That might be possible, but I’m afraid I don’t have the time to test it. I started a new full-time job today, so my availability for deeper dives into Airtable tests is greatly reduced I’m afraid.

[Moe]

We built an extension that solves this problem. It takes 2 (or more) attachment fields and combine them into one automatically.

miniExtensions

Merge Multiple Airtable Attachment Fields - miniExtensions

Instead of moving attachments around manually, just select which fields to grab files from and which field they need to be sent to. Also, you can automate it.