logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
vMIX Title auto mapping - Does it automatically set rows? - Can't map titles to sheets table
Options
Go to last post Go to first unread
Previous Topic Next Topic
andreypetr  
#1 Posted : Saturday, May 28, 2022 12:49:24 AM(UTC)
andreypetr

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.
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Saturday, May 28, 2022 12:56:47 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 284 times
Was thanked: 920 time(s) in 759 post(s)
Originally Posted by: andreypetr Go to Quoted Post
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 ?
Back to top
andreypetr  
#3 Posted : Saturday, May 28, 2022 12:57:37 AM(UTC)
andreypetr

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.
Back to top
doggy  
#4 Posted : Saturday, May 28, 2022 1:00:22 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 284 times
Was thanked: 920 time(s) in 759 post(s)
Originally Posted by: andreypetr Go to Quoted Post
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.
Back to top
thanks 1 user thanked doggy for this useful post.
andreypetr on 5/28/2022(UTC)
andreypetr  
#5 Posted : Saturday, May 28, 2022 1:26:41 AM(UTC)
andreypetr

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.
Back to top
Users browsing this topic
Guest
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.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.093 seconds.