vMix Forums
»
General
»
GT
»
Showing large blocks of text from datasource
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
I'm trying to create a large scrolling page of text - specifically thanks to Patreon supporters. I have a couple hundred and want it to display from a live Google sheet so that its current. How would I go about this, a single row(name) at a time is gonna take a while, but a large page with say 50 or more names x4 would be more possible. Not sure how to grab all those names and display though?
UPDATE I figured it out: Using google sheets - create a new sheet in the same document as your list of names - lets say the names you have inported into the 1st sheet are in column A
In the second sheet (sheet2) A1 cell type Names (for the title) Cell A2=textjoin(", ", 1, Sheet1!A2:A50) (first 50rows of names from sheet1) This will create a text in that cell of Name 1, Name 2, Name 3 etc.
Now you can setup the datasource to pull from the tablename Sheet2 and pipe that into your text area and it will be populated with the comma delimited names from Sheet1. I am using multiple rows with 50 names in each.
Hope this helps someone.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,171 ![Belgium Belgium](/Content/images/flags/BE.png) Location: Belgium Thanks: 288 times Was thanked: 942 time(s) in 778 post(s)
|
Would it not be simpler to have a vertical ticker and just auto next your data source list ? (tweak speed of ticker and datasource next speed for good looks)
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/5/2017(UTC) Posts: 135 Location: UK
Thanks: 15 times Was thanked: 11 time(s) in 9 post(s)
|
I found that even with a 1 second crawl, 100 names is gonna take a while. But maybe I wasnt doing it right? If a ticker would work with several rows at a time it might be OK.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,171 ![Belgium Belgium](/Content/images/flags/BE.png) Location: Belgium Thanks: 288 times Was thanked: 942 time(s) in 778 post(s)
|
Originally Posted by: nowski ![Go to Quoted Post Go to Quoted Post](/Themes/yafpro/icon_latest_reply.gif) I found that even with a 1 second crawl, 100 names is gonna take a while. But maybe I wasnt doing it right? If a ticker would work with several rows at a time it might be OK. I see your point while the crawl can be sped up (setting is speed) one is limited to a auto next of 1 second Scripting could counter that or even get a bit more fancy , all depends on the looks one wants and if viewers actually need to be able to read it ;-) The fact you have control of the data source helped for your own found solution
|
|
|
|
vMix Forums
»
General
»
GT
»
Showing large blocks of text from datasource
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