Rank: Newbie
Groups: Registered
Joined: 4/24/2017(UTC) Posts: 5 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#.XtQXeTpKhhEand 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.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 11/19/2013(UTC) Posts: 127 Location: Hobart Tasmania Australia
Thanks: 13 times Was thanked: 11 time(s) in 8 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-sourcesI 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-cellsto 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
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 11/19/2013(UTC) Posts: 127 Location: Hobart Tasmania Australia
Thanks: 13 times Was thanked: 11 time(s) in 8 post(s)
|
Video example of a running Random Number Gen with GT tile Ash
|
|
|
|
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.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close