30 second countdown timer

[veryallowed]

I’m trying to create a 30/45/60 second countdown timer, how would I create a formula for TIMESTR(NOW()) and +30 seconds into the future. I would then point this new field to the countdown app. sorry im very new to this

[Justin_Barrett]

Welcome to the community, @veryallowed! :grinning_face_with_big_eyes: I’m afraid that won’t work. The NOW() function isn’t updated in real time. Per the docs, it only updates roughly every 15 minutes if your base is open, and roughly every hour if it’s closed.

There currently isn’t a way to get the actual real time in Airtable outside of a scripting environment. This seemed like a fun idea to play with for a few minutes, so I wrote a simple countdown timer script that will work in Airtable’s Scripting app. Be sure to click “show original” below to see the full script. Customize the number strings in the second line to change the options.

gist.github.com

https://gist.github.com/justinsbarrett/7355ecc5d3e4b9d43e9722999aa224a8

countdownTimer.js

// Setup
const timerOptions = ["30", "45", "60"]

// Functions
function showTime(seconds) {
    const min = Math.floor(seconds / 60)
    const sec = seconds % 60
    output.clear()
    output.markdown(`# ${min}:${("0" + sec).slice(-2)}`)
}

This file has been truncated. show original