Aug 24, 2018 09:13 AM
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
Nov 28, 2019 04:50 AM
Did you find a solution?
Aug 10, 2020 11:30 AM
Aug 14, 2020 11:45 AM
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.
Nov 04, 2020 10:58 AM
Thank you so much for this, Miquel. Very helpful.
Nov 23, 2020 09:59 AM
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:
Feb 23, 2021 02:52 PM
@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”?
Feb 26, 2021 03:33 AM
Yes, just use “(https” and “)” (and maybe one space like ") ") and adjust the offsets.
And make sure the url has no parenthesis in between
Jan 26, 2022 01:43 PM
Pretty amazing code, thank you!
Jan 26, 2022 02:38 PM
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.
May 08, 2022 07:12 AM
Thanks Miquel, this is very helpful. :pray: