Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Access the URL of an Airtable attachment using a formula (after attachment update)

Topic Labels: Formulas
9598 13
cancel
Showing results for 
Search instead for 
Did you mean: 
christoph
6 - Interface Innovator
6 - Interface Innovator

Hello everyone,

Who can tell me the formula to get the attachment URL in the new https://v5.airtableusercontent.com/... format? 

The one below only returns the format https://dl.airtable... which no longer works.

 

IF(
AND(
{Attachment},
FIND(
",",
{Attachment}
) = 0
),
RIGHT(
LEFT(
{Attachment},
LEN(
{Attachment}
) - 1
),
LEN(
LEFT(
{Attachment},
LEN(
{Attachment}
) - 1
)
)
- SEARCH(
"https://",
{Attachment}
) + 1
),
IF(
{Attachment},
RIGHT(
LEFT(
RIGHT(
{Attachment},
FIND(
",",
{Attachment}
) - 1
),
LEN(
RIGHT(
{Attachment},
FIND(
",",
{Attachment}
) - 1
)
) - 1
),
LEN(
LEFT(
RIGHT(
{Attachment},
FIND(
",",
{Attachment}
) - 1
),
LEN(
RIGHT(
{Attachment},
FIND(
",",
{Attachment}
) - 1
)
) - 1
)
)
- SEARCH(
"https://",
RIGHT(
{Attachment},
FIND(
",",
{Attachment}
) - 1
)
) + 1
)
)
)

 

 

Thank you!

13 Replies 13

Sir,

I'm missing why simply keeping the image in another table, then linking the destination record to the source record where the image is stored, and creating a URL Generation Formula doesn't work.  Could you please re-capture the Page Designer image above showing the URL you included in there for either image?  And I'm not catching what you're getting at with writing the automation above.  Thanks for your help.

Hi Adam - thanks for your help with this, and for putting together the sample template. I'm pretty bad with the link/lookup stuff, but will use your template and see if I can make it work in ours. Not really keen to have so many additional columns in our main table, but looks like the only solution for now. Thanks again!

Hi Dillon!  The URLs generated via formulas no longer will work I'm afraid. You can read more about it here, and here's the specific bit that talks about it:

Screenshot 2023-05-04 at 2.01.18 PM.png

> Could you please re-capture the Page Designer image above showing the URL you included in there for either image? 

Ah I'm not using a URL, just the lookup field itself:

Screen Recording 2023-05-04 at 2.02.33 PM.gif

That was so simple it made my head hurt 😲, thank you Adam!