Skip to main content
Solved

Extract multiple attachment URL and split to multiple columns


Forum|alt.badge.img+4

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!

Best answer by Livraria_Portug

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

View original

5 replies

Forum|alt.badge.img+12

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
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • October 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.


Forum|alt.badge.img+19
  • Inspiring
  • 3264 replies
  • October 30, 2020
Chris_Guthrie wrote:

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.

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:


Forum|alt.badge.img+4

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


  • Participating Frequently
  • 9 replies
  • November 4, 2020

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


Reply