Help

Re: Formula to pull Attachment property

Solved
Jump to Solution
3639 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alexis_Camacho
4 - Data Explorer
4 - Data Explorer

Hello Community,

When checking the API Doc, I can see Airtable is providing size and thumbnails dimensions for an Attachment
image

Is it possible with a formula (not script) to pull properties from the first attachment?

I tried several things like:
Attachment[0].thumbnails.full.width
… but didn’t succeed :confused:

Regards.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Alexis_Camacho!

As @kuovonne mentioned, the metadata about your attachments is not directly accessible via formula fields, although that would be nice! Please submit this as a feature request to #show-and-tell:product-suggestions and/or to support@airtable.com.

However, keep in mind that ANYTHING that has access to the Airtable API can pull in that attachment metadata information into your fields for you.

You mentioned that you didn’t want to write a script, but for others reading this, you could always write a custom JavaScript that accesses the Airtable API, and then automatically trigger that JavaScript with an Airtable automation.

If you don’t feel like diving into JavaScript, you could also use an external “no-code” automation platform like Integromat, where the attachment metadata is literally just one click of the mouse button. (And then, of course, Integromat can easily integrate with any other app on the web.)

See screenshot below for how this information is easily selectable in Integromat — just click on what you want with your mouse,

image

So, you still have other ways of getting this information into your fields, and it can be automated as well.

See Solution in Thread

3 Replies 3

Welcome to the Airtable Community!

No, this information is not available to formula functions. There aren’t formula functions for attachments.

ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Alexis_Camacho!

As @kuovonne mentioned, the metadata about your attachments is not directly accessible via formula fields, although that would be nice! Please submit this as a feature request to #show-and-tell:product-suggestions and/or to support@airtable.com.

However, keep in mind that ANYTHING that has access to the Airtable API can pull in that attachment metadata information into your fields for you.

You mentioned that you didn’t want to write a script, but for others reading this, you could always write a custom JavaScript that accesses the Airtable API, and then automatically trigger that JavaScript with an Airtable automation.

If you don’t feel like diving into JavaScript, you could also use an external “no-code” automation platform like Integromat, where the attachment metadata is literally just one click of the mouse button. (And then, of course, Integromat can easily integrate with any other app on the web.)

See screenshot below for how this information is easily selectable in Integromat — just click on what you want with your mouse,

image

So, you still have other ways of getting this information into your fields, and it can be automated as well.

Alexis_Camacho
4 - Data Explorer
4 - Data Explorer

Thank you people :tada: :winking_face: