Help

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

Automation script updating duration always results in 0:00 value

Topic Labels: Automations
Solved
Jump to Solution
370 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I am passing a duration type field a number value for update:

let [audioFile, duration] = await concatenateFiles(audioUrls);
console.log(duration); // this is showing a number with decimal
// make the update
await table.updateRecordAsync(record, {
    AudioURL: audioFile,
    Duration: duration,
    Status: {name: "Done"}
});

All 3 fields are updated but the duration is always zero after this update. Do I need to supply something other than a number to the duration data type?

Edit: I tried to use Math.round(duration) to no effect

1 Solution

Accepted Solutions

Can you show a screen captures of the console.log(duration) output?

What are the setting for your duration field? Does it show hours, minutes, and second? Or does it show only hours and minutes?

Duration fields are usually sent in terms of seconds.

See Solution in Thread

2 Replies 2

Can you show a screen captures of the console.log(duration) output?

What are the setting for your duration field? Does it show hours, minutes, and second? Or does it show only hours and minutes?

Duration fields are usually sent in terms of seconds.

Duh Greg. The format was showing minutes but not seconds.