vMix Forums
»
General
»
General Discussion
»
Google Sheets/Excel - list all in column
Rank: Newbie
Groups: Registered
Joined: 5/7/2024(UTC) Posts: 1 ![United Kingdom United Kingdom](/Content/images/flags/GB.png)
|
I am fairly new to VMIX, but have been looking at bring in data through Excel/Google Sheets.
My scenario - we do basketball games, and as an example I want to display the start 5's from each team. At present I have the 5 names in individual text documents (Home starting 5, Away starting 5) along with about different text files for home teamn, away team coaches etc.
I want to accomodate these all within 1 excel/sheets document, under columns and some in different tabs.
I can work out how to connect the excel/sheet, and get it to bring in a row details of that column - but cant find a way of it bring in all 5 names, without having to set the title to bring in the 5 individual names. Although its not to difficult when just 5, when you have a team roster of about 12 and more, makes it more difficult.
So can i import into a title everything under that column, or do i have to stick with text and have multiple files instead of just in the one?
Thanks - Lee
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/23/2019(UTC) Posts: 537
Thanks: 62 times Was thanked: 125 time(s) in 114 post(s)
|
It's all about organizing your data in the spreadsheet, and how you set up your titles. Do you show the teams on one screen at the same time in one title (a)? Or one after the other (b)? One possibility is, to name the columns like Player1,Player2,Player3,Player4, etc., then have home in row 1 and away in row 2. For (a) you have to map the text fields of your title to the specific rows. For (b) you can set the row to "selected". (See https://www.vmix.com/hel...urcesTitleMapping.html).
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Google Sheets/Excel - list all in column
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