Extract multiple attachment URL and split to multiple columns

Livraria_Portug · ‎Oct 29, 2020

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!

Livraria_Portug · ‎Nov 04, 2020

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

See Solution in Thread

Chris_Guthrie · ‎Oct 30, 2020

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

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

kuovonne · ‎Oct 30, 2020

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 · ‎Oct 30, 2020

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 · ‎Nov 04, 2020

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

Josh_Doyle · ‎Nov 04, 2020

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