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: 30
Czech Republic
Location: Jeffry_Ghost

Thanks: 8 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: 4,406
Belgium
Location: Belgium

Thanks: 249 times
Was thanked: 794 time(s) in 647 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: 127
Man
Location: uk

Thanks: 2 times
Was thanked: 22 time(s) in 19 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
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)
Script to export GT Title using DataSource (General Discussion)
by matkeane 2/15/2021 7:58:34 PM(UTC)
Datasource update every 0 milliseconds (General Discussion)
by Pleung 2/12/2021 1:14:26 AM(UTC)
DataSourceAuto NextOn (General Discussion)
by Simsyuk 11/16/2020 6:24:00 PM(UTC)
syntax for API call for "DataSourceSelectRow! (3rd Party Software and Development)
by FrankLeggett 11/11/2020 4:49:25 AM(UTC)
Repeat rows from a datasource in the title (General Discussion)
by Nicolas Alves 11/2/2020 4:10:37 PM(UTC)
Other way to highlight line of a Datasource (General Discussion)
by burie 9/21/2020 8:23:27 AM(UTC)
Save Datasources to Title instead of just in Vmix Preset (Feature Requests)
by FrankLeggett 8/29/2020 12:01:56 AM(UTC)
Countdown trigger from datasource (Feature Requests)
by FrankLeggett 8/28/2020 2:32:23 AM(UTC)
using excel for datasource question (3rd Party Software and Development)
by timbrian 8/2/2020 11:49:41 AM(UTC)
DataSource Photo is Sideways (General Discussion)
by bluesman64 6/1/2020 5:22:59 AM(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.