Help

Extract multiple attachment URL and split to multiple columns

Solved
Jump to Solution
2572 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Livraria_Portug
5 - Automation Enthusiast
5 - Automation Enthusiast

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?
links
Thanks!

1 Solution

Accepted Solutions
Livraria_Portug
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

5 Replies 5
Chris_Guthrie
7 - App Architect
7 - App Architect

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.

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.

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Josh_Doyle
5 - Automation Enthusiast
5 - Automation Enthusiast

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