Hi Everyone,

I am trying to make a hockey period summary page. It is a full page title that allows for 3 info lines of text, corresponding to 3 datasource rows from a google sheet. So far, I have populated the 3 lines with 3 data source rows. How do I display the remaining to datasource rowss? For example if there are 9 goals, I can show the first 3 on the first page, but how do I show the remaining 6? I would like to have another full page populate with the next 3, and so on.

Can this be done in vMix itself, or would I need to use something external such as vMixUTC?

I assume this has been discussed before, but now really sure how to describe what I'm trying to do very well.

Thanks
Mark

Thanks for the reply.

I have attached a photo of my graphic template.

As you can see it has 3 lines for info. These are for up to 3 goals in this case.

I get the stats info from a google sheets with live data, sample spreadsheet included:

Currently, the only way I've been populating the vMix titles is to do the following:

TEAM1.TEXT = B2
TIME1.TEXT = C2
GOALSCORER1.TEXT= D2
ASSISTS1.TEXT = E2
TYPE1.TEXT = F2

TEAM2.TEXT = B3
TIME2.TEXT = C3
GOALSCORER2.TEXT= D3
ASSISTS2.TEXT = E3
TYPE2.TEXT = F3

TEAM3.TEXT = B4
TIME3.TEXT = C4
GOALSCORER3.TEXT= D4
ASSISTS3.TEXT = E4
TYPE3.TEXT = F4

The issue comes when I want to display the next goal, and all other data thereafter. Also, the only way I have figured to sort the data by period, is to setup another sheet and filter all the period 1 goals to the "1st period goals" sheet. If there is a simpler way to do this, I would love to know how.

For titles that I've made so far, I've only had 1 line of information, or "Name and Title", and used the data row select shortcuts to cycle through, or just load up the data sources page screen and change them that way.

Any help, suggestions greatly appreciated.


SUMMARY-SAMPLE.png (82kb) downloaded 0 time(s). HOCKEY.jpg (37kb) downloaded 1 time(s). SUMMARYSAMPLE2.png (76kb) downloaded 1 time(s).

Actually vMix 23 lets you do multiple rows, which I didn't realize wasn't the case before. I forgot I updated to 23 at home, but didn't at the office so when I tried to replicate it there I could only do one row at a time. Shows you how much I use Data Sources. At tonight's game, I resorted to copying and pasting from the google sheet direct into gt title designer and populating the title that way, then exporting as a png. It worked adequately, however I would like to have it populate directly from the spreadsheet, unless vMixUTC or some other 3rd party helper can do this better.

Thanks

datavmix23.jpg (33kb) downloaded 4 time(s).

Thanks again for the info and help.

I didn't even notice it since I don't use data sources all that much. Only noticed it was new for 23 when I tried to do the same thing on our production computer which still has 22.0.0.69. Definitely changes things for sure.

After explanations I realize now this is simpler than I originally thought. Funny what you think when you have a second pair of eyes to look at things. :)

Many Thanks
M