logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Ticker with Google Sheet data source only displaying one column
Options
Go to last post Go to first unread
Previous Topic Next Topic
Tone13  
#1 Posted : Friday, April 15, 2022 10:46:18 AM(UTC)
Tone13

Rank: Advanced Member

Groups: Registered
Joined: 3/29/2020(UTC)
Posts: 101
Australia

Thanks: 20 times
Was thanked: 2 time(s) in 2 post(s)
Hi all,

I have a Google sheet data source that I want to use for a single line scrolling ticker.

The Google Sheet contains three columns for each event. For example

Column 1 has the Team v Team info
Column 2 has the game time info
Column 3 has the venue info

When creating the data source, I only get the option to display one column. So the ticker ends up just showing the Team v team info before moving onto the next team v team in the next row on the sheet. How can I display All three columns after each other for each row before moving onto the next row?

Thanks
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 : Friday, April 15, 2022 11:07:40 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 294 times
Was thanked: 961 time(s) in 795 post(s)
Originally Posted by: Tone13 Go to Quoted Post
Hi all,

I have a Google sheet data source that I want to use for a single line scrolling ticker.

The Google Sheet contains three columns for each event. For example

Column 1 has the Team v Team info
Column 2 has the game time info
Column 3 has the venue info

When creating the data source, I only get the option to display one column. So the ticker ends up just showing the Team v team info before moving onto the next team v team in the next row on the sheet. How can I display All three columns after each other for each row before moving onto the next row?

Thanks


By combining the 3 columns into one (GS can do that to another column or sheet for example)
Back to top
Tone13  
#3 Posted : Friday, April 15, 2022 3:24:04 PM(UTC)
Tone13

Rank: Advanced Member

Groups: Registered
Joined: 3/29/2020(UTC)
Posts: 101
Australia

Thanks: 20 times
Was thanked: 2 time(s) in 2 post(s)
Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Tone13 Go to Quoted Post
Hi all,

I have a Google sheet data source that I want to use for a single line scrolling ticker.

The Google Sheet contains three columns for each event. For example

Column 1 has the Team v Team info
Column 2 has the game time info
Column 3 has the venue info

When creating the data source, I only get the option to display one column. So the ticker ends up just showing the Team v team info before moving onto the next team v team in the next row on the sheet. How can I display All three columns after each other for each row before moving onto the next row?

Thanks


By combining the 3 columns into one (GS can do that to another column or sheet for example)


Really? Sound like a pretty basic limitation of data sources if everything needs to be in one column. Then the sheet isn’t easily editable ??

Surely data sources can look across multiple columns?
Back to top
doggy  
#4 Posted : Friday, April 15, 2022 3:45:40 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 294 times
Was thanked: 961 time(s) in 795 post(s)
Originally Posted by: Tone13 Go to Quoted Post


By combining the 3 columns into one (GS can do that to another column or sheet for example)


Really? Sound like a pretty basic limitation of data sources if everything needs to be in one column. Then the sheet isn’t easily editable ??

Surely data sources can look across multiple columns?


Sure a data source can look accross multiple columns for different text fields in a title and such, ticker only has one such field.
Off course you could write a script that changes the column to be displayed inthat one field and than advance tothe next row , or you could convert rows to collumns (data source option) and just go through the collumns .
If you can not edit the sheet ( see vid below) you can dothe same with a vMix script and send to the title ..

https://www.spreadsheetc...olumns-in-google-sheets/
Back to top
Users browsing this topic
Guest
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.161 seconds.