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
nowski  
#1 Posted : Monday, July 26, 2021 11:18:13 PM(UTC)
nowski

Rank: Advanced Member

Groups: Registered
Joined: 8/5/2017(UTC)
Posts: 135
Location: UK

Thanks: 15 times
Was thanked: 10 time(s) in 8 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.

doggy  
#2 Posted : Tuesday, July 27, 2021 12:09:07 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 284 times
Was thanked: 920 time(s) in 759 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)
nowski  
#3 Posted : Tuesday, July 27, 2021 8:06:03 AM(UTC)
nowski

Rank: Advanced Member

Groups: Registered
Joined: 8/5/2017(UTC)
Posts: 135
Location: UK

Thanks: 15 times
Was thanked: 10 time(s) in 8 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.
doggy  
#4 Posted : Tuesday, July 27, 2021 8:30:22 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 284 times
Was thanked: 920 time(s) in 759 post(s)
Originally Posted by: nowski Go to Quoted Post
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

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.