logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Countdown timer to starttime specified in a Datasource?
Options
Go to last post Go to first unread
Previous Topic Next Topic
TL68  
#1 Posted : Wednesday, January 17, 2024 9:00:27 PM(UTC)
TL68

Rank: Advanced Member

Groups: Registered
Joined: 12/8/2022(UTC)
Posts: 82
Sweden

Thanks: 19 times
Was thanked: 1 time(s) in 1 post(s)
Hi!
Sorry if this is already covered in some other thread and I missed it. If so please point me right.

So I am trying to build a countdown timer that counts down towards a starttime defined in a Google Sheets used as datasource.

What I want is to achieve is to replace the clocktime shown in the vMix tutorial:

Countdown timer to datasource time

Is this possible and if so how?
Thanks in advance for any help with this!
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Wednesday, January 17, 2024 11:00:13 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,216
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: TL68 Go to Quoted Post
Hi!
Sorry if this is already covered in some other thread and I missed it. If so please point me right.

So I am trying to build a countdown timer that counts down towards a starttime defined in a Google Sheets used as datasource.

What I want is to achieve is to replace the clocktime shown in the vMix tutorial:


Is this possible and if so how?
Thanks in advance for any help with this!


Put the data in an invisible textblock , read and convert it with a script to the proper format and put it in the appropriate textblock
Back to top
TL68  
#3 Posted : Wednesday, January 17, 2024 11:06:57 PM(UTC)
TL68

Rank: Advanced Member

Groups: Registered
Joined: 12/8/2022(UTC)
Posts: 82
Sweden

Thanks: 19 times
Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: TL68 Go to Quoted Post
Hi!
Sorry if this is already covered in some other thread and I missed it. If so please point me right.

So I am trying to build a countdown timer that counts down towards a starttime defined in a Google Sheets used as datasource.

What I want is to achieve is to replace the clocktime shown in the vMix tutorial:


Is this possible and if so how?
Thanks in advance for any help with this!


Put the data in an invisible textblock , read and convert it with a script to the proper format and put it in the appropriate textblock


Thanks for responding! Unfortunately I do not know how to script :-(. Any chance you can help me out here with some basic samples?
I have the data source setup working and can make a hidden textblock in a title. But then..?
Back to top
dmwkr  
#4 Posted : Wednesday, January 17, 2024 11:14:43 PM(UTC)
dmwkr

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2019(UTC)
Posts: 556

Thanks: 62 times
Was thanked: 130 time(s) in 118 post(s)
Also, if you have control over the Google Sheet, you can use an aditional column that computes the correct string for vMix Countdown to Time.
Back to top
TL68  
#5 Posted : Wednesday, January 17, 2024 11:36:27 PM(UTC)
TL68

Rank: Advanced Member

Groups: Registered
Joined: 12/8/2022(UTC)
Posts: 82
Sweden

Thanks: 19 times
Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: dmwkr Go to Quoted Post
Also, if you have control over the Google Sheet, you can use an aditional column that computes the correct string for vMix Countdown to Time.

THanks! But not sure I understand... How do you mean that sheets would recalculate every second and then fetch that into a title? Would not that mean a lot of updates for the data source?

EDIT: YES NOW I UNDERSTAND! Sorry, late in the afternoon here in Sweden so brain is a bit slow
Back to top
dmwkr  
#6 Posted : Wednesday, January 17, 2024 11:46:09 PM(UTC)
dmwkr

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2019(UTC)
Posts: 556

Thanks: 62 times
Was thanked: 130 time(s) in 118 post(s)
Originally Posted by: TL68 Go to Quoted Post
Originally Posted by: dmwkr Go to Quoted Post
Also, if you have control over the Google Sheet, you can use an aditional column that computes the correct string for vMix Countdown to Time.

THanks! But not sure I understand... How do you mean that sheets would recalculate every second and then fetch that into a title? Would not that mean a lot of updates for the data source?



No, just write "{0:07:00:00PM|HH:mm:ss}" into the Google Sheets cell. Or, if you prefer to only write "07:00:00PM" into the Google Sheet, use a second cell that computes "{0:07:00:00PM|HH:mm:ss}" for the vMix title.
Back to top
thanks 1 user thanked dmwkr for this useful post.
TL68 on 1/17/2024(UTC)
TL68  
#7 Posted : Wednesday, January 17, 2024 11:53:01 PM(UTC)
TL68

Rank: Advanced Member

Groups: Registered
Joined: 12/8/2022(UTC)
Posts: 82
Sweden

Thanks: 19 times
Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: dmwkr Go to Quoted Post
Originally Posted by: TL68 Go to Quoted Post
Originally Posted by: dmwkr Go to Quoted Post
Also, if you have control over the Google Sheet, you can use an aditional column that computes the correct string for vMix Countdown to Time.

THanks! But not sure I understand... How do you mean that sheets would recalculate every second and then fetch that into a title? Would not that mean a lot of updates for the data source?



No, just write "{0:07:00:00PM|HH:mm:ss}" into the Google Sheets cell. Or, if you prefer to only write "07:00:00PM" into the Google Sheet, use a second cell that computes "{0:07:00:00PM|HH:mm:ss}" for the vMix title.


Hahaha, right when you posted this I posted in the previous post that I figured this out myself!

One more question: is there any way to do this computation in 24h format and not need the AM/PM parameter?

EDIT: figured that one out too. I just use format 0:16:00 instead of 0:04:00 PM. No need to change any setting. Great!

Thanks for all help guys! Really appreciated!
Back to top
doggy  
#8 Posted : Thursday, January 18, 2024 1:42:35 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,216
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: TL68 Go to Quoted Post
Originally Posted by: doggy Go to Quoted Post

Put the data in an invisible textblock , read and convert it with a script to the proper format and put it in the appropriate textblock


Thanks for responding! Unfortunately I do not know how to script :-(. Any chance you can help me out here with some basic samples?
I have the data source setup working and can make a hidden textblock in a title. But then..?


"Scripting for dummies" post
Back to top
thanks 1 user thanked doggy for this useful post.
T68 on 1/18/2024(UTC)
TL68  
#9 Posted : Thursday, January 18, 2024 1:54:13 AM(UTC)
TL68

Rank: Advanced Member

Groups: Registered
Joined: 12/8/2022(UTC)
Posts: 82
Sweden

Thanks: 19 times
Was thanked: 1 time(s) in 1 post(s)
Got the setup working now by doing the calculations for the Countdown to Time parameter in the sheets document I use as data source. Works like a charm!
Back to top
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.124 seconds.