I recently answered a question about retrieving and displaying images (or, more generally, attachments) stored in Spreadsheets and thought it might be useful to a larger audience.
As far as Airtable images (and other attachments) are concerned, the returned value for an ‘Attachment’ type column in Airtable returns an array (i.e. a Thunkable List) of objects. You can obtain the download url for the object using the url property. Here is a very simple example Thunkable program that retrieves and displays an image stored in an Airtable spreadsheet with a column called Attachments:
There’s also a Label in there so you can see a JSON representation of the returned object. Hint: you’ll want to make the height of the Label pretty large if you want to see the whole JSON. I made mine 200.
FYI, here’s a description from the Airtable API documentation of all the fields available in the Attachment object:
Array of attachment objects
Each attachment object may contain the following properties:
id: unique attachment id
url: url, e.g. "https://dl.airtable.com/foo.jpg"
filename: filename, e.g. "foo.jpg"
size: file size, in bytes
type: content type, e.g. "image/jpeg"
width:
height:
width/height, in pixels (these may be available if the attachment is an image)
thumbnails.small.url:
thumbnails.large.url:
url of small/large thumbnails (these may be available if the attachment is an image or document)
thumbnails.small.width:
thumbnails.small.height:
thumbnails.large.width:
thumbnails.large.height:
width/height of small/large thumbnails, in pixels (these will be available if the corresponding thumbnail url is available)
Hope this helps!
-Mark
Thank you.
