Extract multiple attachment URL and split to multi...

[Daniel_Staubli]

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]

Did you find a solution?

[Moe]

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

miniExtensions

Convert Attachments to URLs in Bulk on Airtable - miniExtensions

A tool to extract the URLs of Airtable attachments in bulk with a single click. Get only URLs without files names. Supports scheduling & webhooks.

[Miquel_Capo_Cas]

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.

Salwebs

Diseño web y Marketing Online en Menorca | Salwebs

Diseño web, programación y marketing online en Menorca. Webs hechas a medida fácilmente modificables. Servicios de marketing online para empezar a atraer tráfico a tu nueva web

[Josh_Doyle]

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

[Miquel_Capo_Cas]

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:

Salwebs

Diseño web y Marketing Online en Menorca | Salwebs

Diseño web, programación y marketing online en Menorca. Webs hechas a medida fácilmente modificables. Servicios de marketing online para empezar a atraer tráfico a tu nueva web

[SteelsmithHaus]

@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]

@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]

Pretty amazing code, thank you!

[Hannah_Wiginton]

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

Function - Attachments

Function - Attachments

Process Images and Attachments in your base

On2Air | Accomplish Anything with Airtable – 8 May 21

On2Air: Actions | On2Air

On2Air: Actions is an Airtable automation and workflow tool to integrate and connect your Airtable data with any other software tools used in your business. Create powerful business processes with almost 20 additional action options beyond the...

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