I am currently putting call data from Twilio into Airtable to then transform and present via Stacker. Currently, I can put the call start time (datetime), the call end time (datetime), and the duration (number) from Twilio itself.
I know there is the DATETIME_DIFF() formula, but the issue with this is that it produces an integer, where I am wanting h:mm:ss. I also know you can use the integrating formatting option that Airtable has on Formula fields, which works fine if I was only using Airtable. The difficulty comes in when I need to get this duration time into Stacker. Stacker does not do the same formatting option as Airtable and pulls in the duration integer (as seconds).
I appreciate the nod, @Devan_Kreitzer. However, you didn’t list the code in your reply, or a link to whatever other thread might have it. Please update with either one before this thread auto-closes in order to help other users who might have similar issues. Thanks!
@Devan_Kreitzer For future reference, you don’t need to delete a post if you just want to make changes. The forum lets you edit your post for several days after it was made. Click the pencil icon below the post content to edit it.