# Count down or timer clock

**URL:** <https://community.glideapps.com/t/count-down-or-timer-clock/71971>\
**Category:** Ask for Help\
**Created:** [March 23, 2024, 8:04pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971 "2024-03-23T20:04:39Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curty/32/72679_2.png) [@Curty](https://community.glideapps.com/u/Curty)\
**Post date:** [March 23, 2024, 8:04pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/1 "2024-03-23T20:04:39Z")

</div>

how would i add a count down clock to a live auction site app, I am looking to develop.

tks ! 🙂

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [March 27, 2024, 2:21pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/2 "2024-03-27T14:21:46Z")

</div>

Hello Curty, welcome to Glide 🙂

Create a column with the due date.

**Idea 1**

- One math column to determine “Due date” minus “Now”.
- This will give you an HH:MM:SS format that will update every 10 seconds.

**Idea 2**

- One Date Difference column to determine “Due date” minus “Now”.
- This will give you a positive number that will update every 10 seconds.
- Use math columns to determine the number of days, hours, minutes and seconds left.
- Use a pluralize text column and template columns to build the positive number into a readable countdown.

Idea 2 is similar to idea 1, only the format of what would be displayed is different.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 27, 2024, 3:16pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/3 "2024-03-27T15:16:13Z")

</div>

A video is coming soon about this.

---

<div class="post-metadata">

**Author:** ![Curty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curty/32/72679_2.png) [@Curty](https://community.glideapps.com/u/Curty)\
**Post date:** [March 27, 2024, 11:38pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/4 "2024-03-27T23:38:52Z")

</div>

Thank you so much ! So helpful. Will def try that out ! 👍👍

Curty

---

<div class="post-metadata">

**Author:** ![Curty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curty/32/72679_2.png) [@Curty](https://community.glideapps.com/u/Curty)\
**Post date:** [March 29, 2024, 12:17am UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/5 "2024-03-29T00:17:56Z")

</div>

Hi Nathanael,

First idea, yup good. 2nd idea, which is really what I am looking for a countdown, dont really understand or how do execute on:

\*\* Use a pluralize text column and template columns to build the positive number into a readable countdown.\*

can you direct me or a elaborate a little more please, when you have some time of course !

Thanks

Eoghan.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [March 29, 2024, 10:04am UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/6 "2024-03-29T10:04:18Z")

</div>

I don’t have a computer right now so I can’t send screenshots of the setup.

The idea would be as follows:

Imagine your number of days is 2.15341  
Number of days is floor(2.15341)  
Left over is 0.15341 ( number - floor )  
Number of hours is floor(0.15341\*24) I think.  
Left over is number - floor.  
And so on.

I think this approach would give a column with days, a column with hours, a column with minutes, perhaps a column with seconds until the due date.

The pluralize column allows you to take a number, add a unit, and pluralize the unit based on the number. So it automatically adjusts “1 day left” and “2 days left”.

The template column is to put all of these values together into one value, if needed.

---

<div class="post-metadata">

**Author:** ![Curty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curty/32/72679_2.png) [@Curty](https://community.glideapps.com/u/Curty)\
**Post date:** [March 29, 2024, 3:39pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/7 "2024-03-29T15:39:41Z")

</div>

And ’ pluralize’ option where is that under basic, or computed or ?

Thanks

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [March 29, 2024, 4:00pm UTC](https://community.glideapps.com/t/count-down-or-timer-clock/71971/8 "2024-03-29T16:00:13Z")

</div>

It’s under Experimental / Text. When you create a column, there is also a search function where you can type “Pluralize”.
