vMix Forums
»
General
»
General Discussion
»
vMIX Title auto mapping - Does it automatically set rows?
Rank: Advanced Member
Groups: Registered
Joined: 1/31/2017(UTC)
Posts: 93
Location: KZ
Thanks: 3 times
Was thanked: 10 time(s) in 10 post(s)
|
Hello.
I am trying to automatically match vMIX title with Google Sheets. But unfortunately I can't get it to work.
GT Title structure
Group ----
challenge1.Text
blue1.Text
red1.Text
Group ----
challenge2.Text
blue2.Text
red2.Text
Group ----
challenge3.Text
blue3.Text
red3.Text
......
Google Sheets Pivot Table structure
challenge | blue | red
There are 15 rows in total. I thought I would be able to map it manually once and Append title to another preset with datasource, but it's not possible. So I am looking for a way to map all my data with 1 click. Is there something wrong with my titles?
Thank you.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,439  Location: Belgium Thanks: 309 times
Was thanked: 999 time(s) in 827 post(s)
|
Originally Posted by: andreypetr  Hello.
I am trying to automatically match vMIX title with Google Sheets. But unfortunately I can't get it to work.
GT Title structure
Group ----
challenge1.Text
blue1.Text
red1.Text
Group ----
challenge2.Text
blue2.Text
red2.Text
Group ----
challenge3.Text
blue3.Text
red3.Text
......
Google Sheets Pivot Table structure
challenge | blue | red
There are 15 rows in total. I thought I would be able to map it manually once and Append title to another preset with datasource, but it's not possible. So I am looking for a way to map all my data with 1 click. Is there something wrong with my titles?
Thank you. is your data source "convert rows to collumns" 'd ? Then in title editor "apply to all fields in thsi title" when linking to datasource ?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 1/31/2017(UTC)
Posts: 93
Location: KZ
Thanks: 3 times
Was thanked: 10 time(s) in 10 post(s)
|
No. I have Convert rows to columns switched off. Never used it before.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,439 Location: Belgium Thanks: 309 times
Was thanked: 999 time(s) in 827 post(s)
|
Originally Posted by: andreypetr No. I have Convert rows to columns switched off. Never used it before. time to do so then ;-) see helpfiles Quote:Convert rows to columns: Ticking this box will group all rows in the data source into a single row, numbering the column names in the process. For example a spreadsheet
with Name and Description and 3 rows will become Name1, Description1, Name2, Description2, Name3, Description3 with all data contained in a single row.
|
 1 user thanked doggy for this useful post.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 1/31/2017(UTC)
Posts: 93
Location: KZ
Thanks: 3 times
Was thanked: 10 time(s) in 10 post(s)
|
Wow, it worked! Appreciate your help, doggy. I guess it should be more obvious, or maybe I am just stupid.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 4/26/2025(UTC) Posts: 17   Location: São Paulo Was thanked: 7 time(s) in 2 post(s)
|
Originally Posted by: doggy Originally Posted by: andreypetr Hello.
I am trying to automatically match vMIX title with Google Sheets. But unfortunately I can't get it to work.
GT Title structure
Group ----
challenge1.Text
blue1.Text
red1.Text
Group ----
challenge2.Text
blue2.Text
red2.Text
Group ----
challenge3.Text
blue3.Text
red3.Text
......
Google Sheets Pivot Table structure
challenge | blue | red
There are 15 rows in total. I thought I would be able to map it manually once and Append title to another preset with datasource, but it's not possible. So I am looking for a way to map all my data with 1 click. Is there something wrong with my titles?
Thank you. is your data source "convert rows to collumns" 'd ? Then in title editor "apply to all fields in thsi title" when linking to datasource ? Doggy today I want do this on classification table and I don't know to use convert lines in columns, is perfect! I activate aplly all and ir perfect! Thank so much!
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
vMIX Title auto mapping - Does it automatically set rows?
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
