Re: Formula to extract Image URL from multiple Attachments Field

Daniel_Staubli · ‎Aug 24, 2018

I have multiple images in an attachment field. In another field, I would like to extract just the URL separated bei , oder another character to export it in a CSV-File. Is there an example of a formula to solve this? Thanks very much for support. Regards, Dan

Get_Squaremuse · ‎Nov 28, 2019

Did you find a solution?

Moe · ‎Aug 10, 2020

We built an extension that extracts attachments’ URLs, including multiple ones.

Miquel_Capo_Cas · ‎Aug 14, 2020

I’ve created a free script to achieve this. It generates the airtable formula. You can get the name or url and then play with offsets to adjust the data to output.

Josh_Doyle · ‎Nov 04, 2020

Thank you so much for this, Miquel. Very helpful.

Miquel_Capo_Cas · ‎Nov 23, 2020

Here another script to generate the formula. This one finds strings between strings. So you can specify the strings between you want to catch the url and then adjust the offsets.

this solves the problem of the urls with parenthesis inside the name.

This links has url params with the config you need:

SteelsmithHaus · ‎Feb 23, 2021

@Miquel_Capo_Casasnov I don’t have anything else to say but… I love you.

Okay, I found something. Most of the photos are .jpg, but some are .png. Is there a way to do more than one file type in the “end string”?

Miquel_Capo_Cas · ‎Feb 26, 2021

@SteelsmithHaus
Yes, just use “(https” and “)” (and maybe one space like ") ") and adjust the offsets.

And make sure the url has no parenthesis in between

Mecca_Parker · ‎Jan 26, 2022

Pretty amazing code, thank you!

Hannah_Wiginton · ‎Jan 26, 2022

We have an Extract URLs from Attachment function in our On2Air Actions app.

And with the Actions app, you get an additional 60+ features that integrate with Airtable.

Features like creating Google Docs documents automatically with Airtable data, bulk creating, editing, or deleting multiple records, setting default field values, copying fields, performing financial calculations, syncing Google Sheets, and more.

60+ On2Air Action Features

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable