Create countdown based on time submitted

Hi guys, I am building an app, where I take the current date/time as an input in a form. I use that as the start date/time and then need to add the minutes they have bought as a coupon to make the end time.

From there I need to calculate how much time is left in their coupon. So for example, they buy a 30 min coupon, we can do a countdown when the coupon ends.

Have been trying to figure this out for a few weeks. Anyone can help please?

Hi gurpal,

You can use the start time to which you add 30 minutes to have your end time.
You can use NOW() to get the time at present.
You can use MINUTE() to make a substraction.
Check out:

Hi Karim, thanks for the article.

I have tried it, but the way that Glide sends the data/time to google sheet is
yyyy-mm-ddTHH:mm:ssz

I tried adding the time, but it did not work.

Anything I may be missing?

You have to create a separate column where you apply a TEXT() formula to the data that Glide sends.
This way you will get it in the format that you need
https://support.google.com/docs/answer/3094139?hl=en

1 Like

@Karim, you my dear friend, have helped me solve a problem that I was stuck on for quite a while.
Thank you, kind sir.

1 Like