Help

Re: Formula to get image attachment url

Solved
Jump to Solution
12205 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Carol_Skelly
4 - Data Explorer
4 - Data Explorer

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.

17 Replies 17

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

It starts by grabbing characters beginning at position 100…

…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.

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

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

Alvaro_Hernande
6 - Interface Innovator
6 - Interface Innovator

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
6 - Interface Innovator
6 - Interface Innovator

Same issue as @Alvaro_Hernande here!! 😓

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

Founder @Boltflow

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.

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

Lawrence_Chen
5 - Automation Enthusiast
5 - Automation Enthusiast
I built a service called Air CDN (https://aircdn.io) that lets you keep using Airtable image attachments with static URLs that never expire.

It works by creating a formula column that points to Air CDN's servers, which is updated via a script action whenever an attachment is updated.

Please try it out and let me know if you have any questions or suggestions!