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!
May 03, 2023 01:06 PM
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.
May 03, 2023 07:29 PM
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!
May 03, 2023 11:03 PM
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:
> 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:
May 04, 2023 11:20 AM
That was so simple it made my head hurt 😲, thank you Adam!