Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 30, 2023 01:40 PM
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!
Apr 30, 2023 10:07 PM
Try using an automation to grab the expiring attachment URL and paste it into a text field. I'm curious what you're trying to do given that it expires in 2 hours though?
Apr 30, 2023 10:31 PM
Not sure what you mean. The formula I posted above is able to grab an URL in the known format https://dl.airtable.com/... like it has been for the past 2+ years. The issue is that the URL does not work, even directly after the upload.
All I get is:
The link you're trying to visit is not available. Please visit our support center for more information.
I am using Airtable attachment URLs as part of my workflow to publish designs. An external application grabs the attachment file through the URL as soon as I trigger the process. I can do that within 2 hours of the upload or imply re-upload the files no another field as soon as I start the process assuming that this would generate a new link.
Apr 30, 2023 10:36 PM - edited Apr 30, 2023 10:37 PM
Yeap, attachment URLs from formula fields don't work anymore after the update; it's why I'm suggesting using an automation to grab the URL instead:
May 01, 2023 01:25 AM
Ok, I'll give it a try. Would you mind sharing what you are showing a screenshot of and how to get there?
May 01, 2023 01:56 AM
Hi - I've noticed that Page Designer has similar issues with Image URL at the moment - is this issue connected with Christoph's?
As shown in images attached, the image box in Page Designer shows a broken link instead of a logo, but even the screenshots in the Page Designer page from the Extensions collection show as broken links. Is everyone else having this issue?
May 01, 2023 02:14 AM
Found it in the Automations setup. Seems to work! Thank you!
May 02, 2023 12:40 AM
Yeah it should be, from my understanding any image links with "dl" at the beginning won't work I'm afraid
As a workaround you might need to create a new table with records that hold the images you use for your Page Designer, and then link them and use lookups to display those images. You can then reference them within your Page Designer. Not the most elegant solution, but it works
re: screenshots from the Extensions collection show as broken links
Hmm, I have no idea why that's happening and whether it's linked to this, but I can tell you I see the same thing you do!
May 02, 2023 01:35 AM
Thanks Adam... We've always had a separate table just for the image attachments for Page Designer (as pictured below). Now it sounds like I'm going to need ANOTHER table just to lookup urls of images in THIS existing table? You're right - this is a very clunky workaround, and seems crazy for an internal extension to need this for such a basic function!
Cheers,
Andrew
May 02, 2023 06:13 AM
Oh nah, your existing table would work fine, you'd just need to add links to your data records to it:
And in Page Designer you can see that the lookup fields would be available for selection here:
And here's a link to the base if you'd like to check it out yourself
I'm hoping that I've missed something and that there's a better way to do it too honestly