Rank: Advanced Member
Groups: Registered
Joined: 9/9/2017(UTC) Posts: 36  Location: Jeffry_Ghost Thanks: 10 times Was thanked: 2 time(s) in 2 post(s)
|
Hi guys,
is there any options how to use one data source for multiple rows.
Example, I use titles as information of tmie of each athlete. We use 4 lanes, so i worked it around as for each lane different datasource (same google sheet). But i would like to use it from data source. Like first row is option selected but for rest of 3 lanes i would like to use other 3 rows below that and at same time be able to move rows.
Example Row1 time of athlete n1 Row2 time of athlete n2 Row3 time of athlete n3 Row4 time of athlete n4
and then Row5 time of athlete n1 Row6 time of athlete n2 Row7 time of athlete n3 Row8 time of athlete n4 ëtc.
via script i am somehow able to work it out but it's not suitable for rest of the crew
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,318  Location: Belgium Thanks: 299 times Was thanked: 977 time(s) in 810 post(s)
|
Originally Posted by: Jeffry_Ghost  Hi guys,
is there any options how to use one data source for multiple rows.
Example, I use titles as information of tmie of each athlete. We use 4 lanes, so i worked it around as for each lane different datasource (same google sheet). But i would like to use it from data source. Like first row is option selected but for rest of 3 lanes i would like to use other 3 rows below that and at same time be able to move rows.
Example Row1 time of athlete n1 Row2 time of athlete n2 Row3 time of athlete n3 Row4 time of athlete n4
and then Row5 time of athlete n1 Row6 time of athlete n2 Row7 time of athlete n3 Row8 time of athlete n4 ëtc.
via script i am somehow able to work it out but it's not suitable for rest of the crew Consider converting rows to columns option other option is to specify the row number in the connection instead of selected
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 5/14/2013(UTC) Posts: 142  Location: uk Thanks: 2 times Was thanked: 24 time(s) in 20 post(s)
|
Also, Look at utilising some of the functionality within Google sheets to format the data before it hits mix, I Find the transpose function very useful , an example can be found at the link below that uses multiple sheets to sort and format for vmix https://docs.google.com/...ayxcQoI/edit?usp=sharing
|
|
|
|
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