logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Ability to Map ANY Excel cell to ANY text field
Options
Go to last post Go to first unread
Previous Topic Next Topic
spencerm24  
#1 Posted : Wednesday, June 13, 2018 12:47:29 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
I use Excel integration all the time, and it would be nice to have a way to map say cell B4 to the "headline" text, and F6 to the "line 2 text". I would use this for full screen standing boards with more than one entry, you have a bunch of teams, their point totals, wins, all is currently stored as a chart in Excel, but I can only use one line at a time the way the Excel Data source is set up.
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
IceStream  
#2 Posted : Wednesday, June 13, 2018 9:00:44 PM(UTC)
IceStream

Rank: Advanced Member

Groups: Registered
Joined: 3/7/2012(UTC)
Posts: 2,636
Man
Location: Canada

Thanks: 33 times
Was thanked: 506 time(s) in 475 post(s)
@ spencerm24

This is already possible unless I have misunderstood you.
Each text field in an XAML Title can be mapped to its own data source, it can be from the same sheet or a completely different data source.



Ice
Back to top
WWW
spencerm24  
#3 Posted : Wednesday, June 13, 2018 9:21:13 PM(UTC)
spencerm24

Rank: Advanced Member

Groups: Registered
Joined: 9/23/2017(UTC)
Posts: 249
Location: Toronto

Thanks: 13 times
Was thanked: 19 time(s) in 17 post(s)
IceStream wrote:
@ spencerm24

This is already possible unless I have misunderstood you.
Each text field in an XAML Title can be mapped to its own data source, it can be from the same sheet or a completely different data source.



Ice


hmmmm, perhaps I can't figure out how to map multiple data points on a single data source. I have a chart that looks like this:

TEAM 1 4 1 1 8
TEAM 2 3 3 1 7
TEAM 3 2 4 0 5
TEAM 4 1 4 1 4
TEAM 5 0 5 1 1



I want to be able to map all those to different text fields, and using data source, unless I add a different data source for each line, I can't find a way to do this. I'd have to have 5 data sources in this example. It lets me select the column I use, but not the row. In the above example, the ability to select the row as well is critical. For larger graphics with 10-12 lines, that would mean 10-12 data sources.
Back to top
IceStream  
#4 Posted : Wednesday, June 13, 2018 9:41:30 PM(UTC)
IceStream

Rank: Advanced Member

Groups: Registered
Joined: 3/7/2012(UTC)
Posts: 2,636
Man
Location: Canada

Thanks: 33 times
Was thanked: 506 time(s) in 475 post(s)
@ spencerm24

You can convert rows to columns in the data source settings.
It might not be what you want or easily managed, but it is possible.


Ice
Back to top
WWW
doggy  
#5 Posted : Wednesday, June 13, 2018 11:25:28 PM(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)
IceStream wrote:
@ spencerm24

You can convert rows to columns in the data source settings.
It might not be what you want or easily managed, but it is possible.


Ice


is what we do for a ranking display
Back to top
Users browsing this topic
Guest (2)
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.083 seconds.