Re: Formula to pull Attachment property
Hello Community,
When checking the API Doc, I can see Airtable is providing size and thumbnails dimensions for an Attachment
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.
Accepted Solutions
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,
So, you still have other ways of getting this information into your fields, and it can be automated as well.
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,
So, you still have other ways of getting this information into your fields, and it can be automated as well.
