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
MickeyMJJ  
#1 Posted : Saturday, January 22, 2022 1:52:20 AM(UTC)
MickeyMJJ

Rank: Advanced Member

Groups: Registered
Joined: 12/14/2018(UTC)
Posts: 129
France
Location: Clermont-Ferrand

Thanks: 30 times
Was thanked: 9 time(s) in 8 post(s)
Hello,
I created a GT Title title with 2 texts.
These texts are linked to a column of an Excel file with the vMix data source.

For one of the texts, it displays the text of the selected line, that's good.
On the other hand, for the second text, I would like it to display the next line from the selected one.
I can't find how to do this.

Anyone have an idea?
Vince Beck  
#2 Posted : Saturday, January 22, 2022 3:06:39 AM(UTC)
Vince Beck

Rank: Advanced Member

Groups: Registered
Joined: 7/28/2019(UTC)
Posts: 351
United States
Location: Santa Rosa

Thanks: 1 times
Was thanked: 53 time(s) in 51 post(s)
By default, data sources use columns, not rows. You can change that in the data source preferences.
MickeyMJJ  
#3 Posted : Saturday, January 22, 2022 3:09:45 AM(UTC)
MickeyMJJ

Rank: Advanced Member

Groups: Registered
Joined: 12/14/2018(UTC)
Posts: 129
France
Location: Clermont-Ferrand

Thanks: 30 times
Was thanked: 9 time(s) in 8 post(s)
Thank you for your reply.
In fact, the Excel file is a registration list.
In my GT Title, I want to indicate the current person (line that I select manually), but also the next person (therefore next line).
Vince Beck  
#4 Posted : Saturday, January 22, 2022 3:24:54 AM(UTC)
Vince Beck

Rank: Advanced Member

Groups: Registered
Joined: 7/28/2019(UTC)
Posts: 351
United States
Location: Santa Rosa

Thanks: 1 times
Was thanked: 53 time(s) in 51 post(s)
In your data source manager, go to settings, and check convert rows to collumns.
doggy  
#5 Posted : Saturday, January 22, 2022 3:39:26 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: Vince Beck Go to Quoted Post
In your data source manager, go to settings, and check convert rows to collumns.


to add to Vince's response

from the helpfiles

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.

if that doesn't suit you one can always revert to using some script
MickeyMJJ  
#6 Posted : Saturday, January 22, 2022 4:08:55 AM(UTC)
MickeyMJJ

Rank: Advanced Member

Groups: Registered
Joined: 12/14/2018(UTC)
Posts: 129
France
Location: Clermont-Ferrand

Thanks: 30 times
Was thanked: 9 time(s) in 8 post(s)
Thank you for your answers.

I tried the option to convert to row, but it's not manageable with 26 columns. Then I can no longer choose the current person easily (manual selection).
I don't know if a script can do this?

All I need is that when I choose a line, the Gt Title shows me the chosen line and the next line (+1)
MartLeib  
#7 Posted : Saturday, January 22, 2022 5:36:09 AM(UTC)
MartLeib

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2017(UTC)
Posts: 189
Estonia

Thanks: 1 times
Was thanked: 52 time(s) in 42 post(s)
Why not use excel for it? Add new column that references next line? Done.
Users browsing this topic
Guest (3)
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.