Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Image URL Formula?

Topic Labels: Formulas
Solved
Jump to Solution
1031 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m hoping someone might be able to help me figure this out… To put it simply I have one column full of images (just one image in each cell) but 1000’s of images total. I need another column, residing next to it that contains the URL for each image, and I haven’t found an easy way to do this aside from just copy and pasting each individual URL. Which gets very repetitive and time consuming doing this thousands of times. Is there a formula out there that could pull these image URL’s and fill each corresponding cell (to the right of the image cell) with the URL (of the image in the cell to the left of it)? Maybe I’ve just been looking at it for too long and there’s a much simpler solution?

1 Solution

Accepted Solutions

Hi @Michael_Baugher ,

You can use a formula like this:

SUBSTITUTE(
  MID(
    {Attachment Field},
    FIND(
      "https://dl",
      {Attachment Field}
    ),
    250
  ),
  ")",
  ""
)

Just make sure to replace {Attachment Field} with the actual name of the field you’re using to store them.

See Solution in Thread

3 Replies 3

Hi @Michael_Baugher ,

You can use a formula like this:

SUBSTITUTE(
  MID(
    {Attachment Field},
    FIND(
      "https://dl",
      {Attachment Field}
    ),
    250
  ),
  ")",
  ""
)

Just make sure to replace {Attachment Field} with the actual name of the field you’re using to store them.

Worked like a charm! Thanks so much, saved me hours of copy/pasting!