Rank: Advanced Member
Groups: Registered
Joined: 12/14/2018(UTC) Posts: 129 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?
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/28/2019(UTC) Posts: 351 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.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/14/2018(UTC) Posts: 129 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).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/28/2019(UTC) Posts: 351 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.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,218 Location: Belgium Thanks: 291 times Was thanked: 955 time(s) in 790 post(s)
|
Originally Posted by: Vince Beck 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
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/14/2018(UTC) Posts: 129 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)
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/23/2017(UTC) Posts: 189 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.
|
|
|
|
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