Help

Get length of MP3

Topic Labels: Formulas
2015 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kim_g
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,
I have an attachment column with mp3 files. I need to know the length of each mp3 file. Is there a way to do this by using a formula? The API does not provide anything I can use to this.

Best,
Kim

1 Reply 1
Dalton
6 - Interface Innovator
6 - Interface Innovator

Hi Kim,

Thanks for reaching out to the community about this!

At the moment there is not a direct way to pull the length of an MP3 file from the attachment field. I can see how this would be helpful to those adding MP3 files to their base. I’ve shared your vote for the idea with our team, and you can keep track of new product updates / feature releases at www.airtable.com/whatsnew.

A quick workaround is to format your file names to include the length of the MP3 and then use a LEFT(), RIGHT(), or MID() formula function to pull that information from the file.

It would look something like this:

Filename: bestsoundbyteever_543

LEFT({Attachments},FIND("_",{Attachments})+1))

I hope this helps! If it does, would you mind marking this post as solved? If not, let me know what other questions you have.