Extract multiple attachment URL and split to multiple columns

[Livraria_Portug]

Hi!
I have a Lookup column that gets one or more images from another table. Now I need to get each image link in its own column.
I already have the formula to extract the images URLs, but how do I get each of the URLs in a separated column?

Thanks!

[Chris_Guthrie]

This should be possible, but there isn’t enough information yet.

1. Will every record have the same input number of attachments?
2. What is the purpose of splitting them into their own columns? Can they not be entered into these destination columns to begin with?
3. Likely this will require a custom script to achieve the result. The script can be triggered manually or with an automation.

[kuovonne]

I agree that understanding the design of your data and your ultimate purpose would be helpful.

If your data has a very simple structure (e.g. fixed number of attachments, predictable naming, etc.), it might be possible to do this with a series of formula fields. There are some very creative formulas that extract items in a list. However, if you want to do much else a scripting solution might be better.

Also keep in mind that per this topic, Airtable does not support being used as a CDN for attachments.

[Bill_French]

Chris_Guthrie:

Can they not be entered into these destination columns to begin with?

This is the right question (and solution). Perhaps there’s some legacy system that is asserting this, but one of the best ways to create good data, is to start with good data. :winking_face:

[Livraria_Portug · Accepted solution]

Thanks!
I managed to do what I needed following @W_Vann_Hall 's solution in this post:

Extracting Hashtags (was: Formula Assistance) Hire a consultant

Building out a social media calendar where one of the fields indicates the Copy that will be going in a post. Was hoping to create a separate formula field that automatically searched the Copy field for any hashtags and listed them there. Support’s initial response sent me the formula below as a start, but it only pulls in the first # within the copy section. Wasn’t sure if anyone had any ideas/suggestions on how to expand it to pull/list all of them. Thanks in advance! IF( FIND(" “,{Notes},F…

[Josh_Doyle]

@Livraria_Portuguesa - would you mind sharing your solution for how you extracted the URL’s for the attachments into a single column?