Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Duration API in h:mm and not seconds

133 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there. I have created a time tracking app and used Airtable as backend. While it works perfectly for all get API requests I have troubles with post requests.

Users need to fill in a duration that they have worked. While everything else works absolutely fine I can't work out how I can create an API Post request where the user can input the duration using h:mm format and not seconds. I can work around it in Airtable using the formula but it is not practical to have App users type in their work time in seconds.

Is there a way to create a working post request? I am slowly starting to loose hope in Airtable. 

thx in advance

1 Reply 1

Are you using the Web API? Have you tried setting the typecast parameter to true? 

Another option is to have users enter their data in h:mm format in a text field and then use a formula field to convert to numeric format (if necessary).