May 27, 2019 08:25 AM
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…
May 27, 2019 08:40 AM
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.
May 27, 2019 08:56 AM
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.
May 27, 2019 02:20 PM
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.
May 28, 2019 02:07 AM
The two forms are separated and i retrieve the pictures from the forms of other tables.
May 28, 2019 06:19 PM
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.
Jan 02, 2020 12:31 PM
Could you make concatenating two images fields into another? If yes, would you mind sharing how using Integromat?
Jan 02, 2020 10:13 PM
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.
Aug 10, 2020 06:50 AM
We built an extension that solves this problem. It takes 2 (or more) attachment fields and combine them into one automatically.