Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to surface the Thumbnail of an uploaded image

Topic Labels: Formulas
2060 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jemima_Garthwai
4 - Data Explorer
4 - Data Explorer

Hi there,

Our users are uploading multiple images to an attachment field. I need to grab the URL of the first of these images in a large thumbnail size (not the full resolution URL).

I am using 2 steps right now.

  1. a formula field to render the images as coma separated urls.
  2. a second field in which I use a formula to successfully grab just the first of the images as a url.

BUT I can’t figure out how to get the lower resolution thumbnail versions of this image, which I know Airtable has hidden somewhere.

Can anyone help?

Here’s the formula I’m using for now to grab the single image url.
MID({SINGLE IMAGE WORKINGS},FIND("(",{SINGLE IMAGE WORKINGS})+1,FIND(")",{SINGLE IMAGE WORKINGS})-FIND("(",{SINGLE IMAGE WORKINGS})-1)

1 Reply 1

Hi @Jemima_Garthwaite - I don’t think this is possible using a formula. The thumbnail URLs are in the API for your base, so you could access them programatically via this, but, looking at an example image that I uploaded to a base, it doesn’t look like you can derive the either of the thumbnail URLs from the primary image URL.

JB