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
Jeffry_Ghost  
#1 Posted : Friday, January 20, 2023 8:33:52 PM(UTC)
Jeffry_Ghost

Rank: Advanced Member

Groups: Registered
Joined: 9/9/2017(UTC)
Posts: 36
Czech Republic
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
doggy  
#2 Posted : Friday, January 20, 2023 9:00:25 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 288 times
Was thanked: 947 time(s) in 782 post(s)
Originally Posted by: Jeffry_Ghost Go to Quoted Post
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

Henny  
#3 Posted : Saturday, January 21, 2023 12:36:34 AM(UTC)
Henny

Rank: Advanced Member

Groups: Registered
Joined: 5/14/2013(UTC)
Posts: 140
Man
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
Users browsing this topic
Similar Topics
Access API data through DataSource (General Discussion)
by Papo 4/26/2024 3:12:00 AM(UTC)
Feature in GT Title Designer and DataSource (Feature Requests)
by Ham4u62 3/27/2024 12:07:21 AM(UTC)
DataSource RowSelected Plus 1 (GT)
by Kibim 3/6/2024 8:00:53 AM(UTC)
Triggering an transition in a GT Tile based on a datasource (3rd Party Software and Development)
by famt 2/13/2024 10:35:01 AM(UTC)
Countdown timer to starttime specified in a Datasource? (GT)
by TL68 1/17/2024 9:00:27 PM(UTC)
Add datasources in vmix Preset Bundle (Feature Requests)
by plizon 7/27/2023 7:05:09 PM(UTC)
DataSource superscript (General Discussion)
by Maku 7/26/2023 5:56:29 AM(UTC)
Shortcut to set Preset DataSource (General Discussion)
by WatsonPrunier 5/24/2023 5:13:29 AM(UTC)
XPath Node Vs Attribute as DataSource (General Discussion)
by ckshofner 5/12/2023 12:57:53 AM(UTC)
DataSource AutoNextOn in Companion Not Working (GT)
by geekazine 2/12/2023 7:38:43 AM(UTC)
Scripting DataSource multiple rows (General Discussion)
by cchhita 1/14/2023 2:18:36 AM(UTC)
DataSourceSelectRow and Dynamic Value (General Discussion)
by nowski 1/2/2023 8:07:27 PM(UTC)
How to script: Datasource to settings (General Discussion)
by nidarosvideo 12/5/2022 5:34:50 AM(UTC)
transform to random search DataSourceSelectRow (General Discussion)
by Fabianogc 9/28/2022 6:46:43 AM(UTC)
random search DataSourceSelectRow (General Discussion)
by Fabianogc 9/27/2022 12:35:56 AM(UTC)
PNG DataSource - Only some images work (GT)
by jayemel423 9/11/2022 4:50:56 AM(UTC)
GT Title datasource stop (GT)
by KGunderman 9/10/2022 1:24:59 AM(UTC)
Change source file location (video) depending on datasource (google sheet) (General Discussion)
by 33Fraise33 8/14/2022 8:18:39 PM(UTC)
Read data from Datasource (3rd Party Software and Development)
by Korne_B 8/8/2022 2:42:09 AM(UTC)
.TXT datasource second line? (General Discussion)
by andreypetr 6/30/2022 2:38:11 AM(UTC)
Trying to Pull Title from DataSource (General Discussion)
by imprintuniverse 4/25/2022 12:31:31 AM(UTC)
Shortcut issue when doing DataSourceSelectRow function (General Discussion)
by nidarosvideo 4/12/2022 7:00:34 PM(UTC)
Title Images not Updating from DataSource (GT)
by Chris Daum 12/20/2021 6:29:08 PM(UTC)
Different datasources referring to the same excel file (General Discussion)
by fabfab10 9/18/2021 12:47:18 AM(UTC)
Change colors by datasource (Feature Requests)
by xun 9/11/2021 10:49:29 AM(UTC)
Datasources and values used in variables (General Discussion)
by nowski 9/8/2021 8:23:29 AM(UTC)
Reading a datasource value in VB Script (3rd Party Software and Development)
by tom@24bit.io 8/20/2021 2:35:41 AM(UTC)
Showing large blocks of text from datasource (GT)
by nowski 7/26/2021 11:18:13 PM(UTC)
Making "DataSourceSelectRow" work (General Discussion)
by Riddlez 5/21/2021 12:07:04 PM(UTC)
Change datasource of titles via shortcuts (Feature Requests)
by andreypetr 3/5/2021 10:18:20 PM(UTC)
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.