Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Integromat and Duration field

Solved
Jump to Solution
955 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Broadcast_Super
4 - Data Explorer
4 - Data Explorer

Hey, guys.

I have an issue with an integration of mine.

I’m extracting a time from a string from Google sheets and then putting that time into Airtable.
I want to put it into the duration field, but it will not accept it.

Does anyone have any idea of how to format this correctly or work around the duration field paramaters?

Thank you!

1 Solution

Accepted Solutions
Matthew_Thomas
7 - App Architect
7 - App Architect

Welcome to the community @Broadcast_Supervisor!

What does the string that you’re extracting from the Google sheets look like? In Airtable, the duration field accepts an integer input in terms of seconds (e.g. 6 min 23 sec would be an input of 383). In the duration field, you can then customize how this is displayed, like so:

Screen Shot 2020-06-05 at 8.32.24 AM


If this answers your question, please consider marking it as “solution”. If not, I’m happy to work with you further. Thanks!

See Solution in Thread

2 Replies 2
Matthew_Thomas
7 - App Architect
7 - App Architect

Welcome to the community @Broadcast_Supervisor!

What does the string that you’re extracting from the Google sheets look like? In Airtable, the duration field accepts an integer input in terms of seconds (e.g. 6 min 23 sec would be an input of 383). In the duration field, you can then customize how this is displayed, like so:

Screen Shot 2020-06-05 at 8.32.24 AM


If this answers your question, please consider marking it as “solution”. If not, I’m happy to work with you further. Thanks!

Matthew_Thomas
7 - App Architect
7 - App Architect

Hey @Broadcast_Supervisor,

If the answer I posted above solves your question, would you mind marking it as the “solution” so others searching the forums can easily find the information? If it doesn’t answer your question, is there more information you can share?

Thanks!