As @Justin_Barrett said, you can not get the duration of a video file from Airtable. This information is never provided by Airtable. (Although other metadata about video files is available via Airtable’s API, such as the size of the video in bytes.)
However, other apps like Google Drive & Dropbox do make the duration of a video file (in milliseconds) accessible via their APIs.
So, as Justin said, you could write your own custom JavaScript script to access this duration information from the Google Drive URL or the Dropbox URL, using their APIs. (Justin is also a fantastic script writer, so you might be able to hire him to help you create these JavaScripts for your Airtable base.)
Alternatively, if you don’t want to write any code at all, you can just do what I’ve done for other clients in the past who have needed this functionality:
They simply upload the video file to Google Drive first, and then I have Integromat automatically move the file into Airtable and grab the duration of the video file at the same time. Then, Integromat automatically types in the duration of the video into Airtable. (Integromat is a low-code/no-code automation platform that doesn’t require any coding knowledge.)
p.s. I am a professional Airtable consultant and an Integromat Partner, and the Integromat link contains my personal referral code. If you have a budget for your project and you’d like to hire an expert consultant to help, please feel free to contact me through my website at ScottWorld.com.
