logo

Live Production Software Forums


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

Notification

Icon
Error

Options
Go to last post Go to first unread
heckie  
#1 Posted : Monday, June 1, 2020 8:05:02 AM(UTC)
heckie

Rank: Newbie

Groups: Registered
Joined: 4/24/2017(UTC)
Posts: 5
Man
Location: Oakland California

Thanks: 4 times
Hi guys, i'll like to get the following into Google Sheets to be use as datasource.


1 Users name that are viewing the live show
2 Send that info to vMix to be use on any graphic - To show who is watching the show.
3 collected on a google sheet all that data by rows - names last name and city

Why I need this info?

I need to make a ruffle at the end of the show and having the names on a google sheets will let me use

www.aplinet.org/aplinet/...;apli=sorte#.XtQXeTpKhhE

and pick 3 names to be winners.


Is there a tutorial where I can follow the step by step to make this happen.

Much appreciate any guidance.




Ash  
#2 Posted : Saturday, June 20, 2020 10:02:52 AM(UTC)
Ash

Rank: Advanced Member

Groups: Registered
Joined: 11/19/2013(UTC)
Posts: 124
Location: Hobart Tasmania Australia

Thanks: 13 times
Was thanked: 8 time(s) in 7 post(s)
Hi hekie

First off, create your Google Sheet and Permissions using the guide at
https://www.vmix.com/kno...s-with-vmix-data-sources

I have a sheet created in the first,second and third row as:

Name1, <random Number>
Name2,<random number>
Name3,<random number>

Create a GT Title to contain the data, showing Names and Numbers.

Link the Google Sheet to the GT Title (as per vMix instructions above)

Then add the script from https://stackoverflow.co...umbers-in-multiple-cells
to the Google Sheet.

You can modify the code at var number = Math.floor(Math.random() * 9999) + 1; for a max number

Select the 3 rows in column 2 of the google sheet and run the script.

The random numbers will be generated in the columns and will update into your GT Title

This is a brief explanation but I am out of time at the moment, but I have tested this and it works.

If you need more clarification, I can work up a more informed tutorial.

Probably off topic but you can also use VB code in a script if you have vMix 4k or Pro, something like

dim gen as system.random = new system.random()
dim i = Input.Find("news.gtzip")
i.Text("Headline.Text") = "Hello World!"
i.Text("Description.Text") = gen.Next(1, 10000)


While this is a small tutorial on "random number generation" methods to be imported into vMix, please be aware that the generation of the numbers may not be an accurate and fair generator. You may have to do a bit more reading to be satisfied it is fair to use a generator in a raffle or other gambling environment.

Ash

Ash  
#3 Posted : Saturday, June 20, 2020 7:47:17 PM(UTC)
Ash

Rank: Advanced Member

Groups: Registered
Joined: 11/19/2013(UTC)
Posts: 124
Location: Hobart Tasmania Australia

Thanks: 13 times
Was thanked: 8 time(s) in 7 post(s)


Video example of a running Random Number Gen with GT tile



Ash

Users browsing this topic
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.