API_EditRecord to Duration field

Question

I'm working on using JavaScript to get the duration of a video, and I want to upload this duration into QB via API Call.

I can't seem to get the time formatted correctly to where the Duration field is able to read correctly once uploaded.

If I have it in full milliseconds, QB thinks the whole number is days...

Anyone know the trick for what format I need the time to be in for API calls?

------------------------------
Ryan Stanford
------------------------------

MarkShnierYou · Answer

A pure guess on my part but I suggest trying the same way you would enter it manually. For example Quick Base understands seconds and minutes and hours.
e.g.
5.2 minutes
123 seconds
0.1 hours

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community