Formula to get image attachment url

[Carol_Skelly]

I have an attachment field containing images. I see that the stored attachment object has a url property. In another formula field I would like to show just the attachement url. Any ideas?

Thanks.

[Justin_Barrett · Accepted solution]

For more than three attachments, keep expanding the second formula. Notice the pattern in the MID() functions:

Justin_Barrett:

TRIM(MID(Expanded, 100, 200))

It starts by grabbing characters beginning at position 100…

Justin_Barrett:

    & IF(LEFT(Expanded, 1) > 1, ", " & TRIM(MID(Expanded, 400, 200)))
    & IF(LEFT(Expanded, 1) > 2, ", " & TRIM(MID(Expanded, 700, 200)))

…then position 400, then position 700. In short, we’re adding 300 each time to grab the next URL. Just keep that pattern going. The next one would start at position 1000, then 1300, then 1600, etc.

Also notice the pattern in the comparisons made before grabbing each subsequent piece. Each line increases the number we’re comparing against from the start of {Expanded}. The first one is just grabbed outright because we know we have at least one URL. If we have more than one—IF(LEFT(Expanded, 1) > 1—we grab the next piece. If more than 2, grab the next one. Keep that pattern going as well.

Also, for more than 9 attachments, you would need to change all instances LEFT(Expanded, 1) to LEFT(Expanded, 2).

A lot of programming is about finding patterns. Learn to see the patterns in the data you’re playing with, and you can write code to find things based on those patterns.

[Bigland_Bigland]

Thank you so much. You save my day ! Good Work and clear explanations.

[Lynnsey_Schneid]

Thanks so much, you have saved me hours of work!

[Alvaro_Hernande]

Suddenly, today, all those formulas above have stopped working. By some reason Í do not understand. Maybe Airtable did un update to block this way of getting a permanent URL from attachments. Anyone knows why this is happening? Thank's in advance. 🙂

[gaston]

Same issue as @Alvaro_Hernande here!! 😓

@Justin_Barrett @ScottWorld any idea on what might be happening?

[ScottWorld]

Formulas can no longer be used to get URLs of attachments, but non-working URLs will still show up to prevent old formulas from completely breaking. (For example, an old formula might have pulled a filename out of the attachment field in addition to the URL. The URL still won't work anymore, but the filename would still be valid.)

p.s. I would encourage people to post questions about Airtable's attachment changes at TableForums.com, because all the top Airtable consultants/experts are answering questions there. I'm not sure how many of them are still monitoring this thread or are still monitoring this community anymore.

[TimBurnettxx1]

This has broken for me as well which is very frustrating.