Help

Formula to surface the Thumbnail of an uploaded image

Topic Labels: Formulas
1604 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