logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Combining Data Sources on titles?
Options
Go to last post Go to first unread
Previous Topic Next Topic
Argo82  
#1 Posted : Monday, February 12, 2018 12:40:47 PM(UTC)
Argo82

Rank: Advanced Member

Groups: Registered
Joined: 11/21/2016(UTC)
Posts: 48

Thanks: 8 times
Was thanked: 7 time(s) in 5 post(s)
Hi Everyone,

I am setting up a spreadsheet for team rosters and stats for a lower third. Right now my excel file has columns for:

Player #
Player First name
Player Last Name
Home City
Home State/Province

Is there a way to combine the "Player #, Player First Name, Player Last name" in one text field, and combine "Home City, Home State/Province" data in a second text field on the same title, or would I have to make a text field for each bit of data? I was a bit curious if the "Format" field (set at {0}) could do this in some way, but I've only managed to change the position of the text with that.

Thanks
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 : Monday, February 12, 2018 12:54:12 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
As far as i know it is not possible to combine with the format field but:

as you are setting up a spreadsheet yourself you could either combine the desired fields during creation or if the data needs to stay seperated for some reason you could add a collumn with a formula that combines multiple cells and choose that colum for displau in your title


other option is let the title combine the data but is a bit more elaborate to prepare ( hidden fields that are combined to be displayed in the wanted text field ) by means of codebehind of the title

been discussed here too : https://forums.vmix.com/default.aspx?g=posts&t=11522

we often receive spreadsheets or lists with data seperated dispite having asked to have them combined , so a quick combine column makes the later use to our desire practical and quicker rather than trying to let them change the source



Back to top
thanks 1 user thanked doggy for this useful post.
Argo82 on 2/12/2018(UTC)
Argo82  
#3 Posted : Monday, February 12, 2018 1:09:19 PM(UTC)
Argo82

Rank: Advanced Member

Groups: Registered
Joined: 11/21/2016(UTC)
Posts: 48

Thanks: 8 times
Was thanked: 7 time(s) in 5 post(s)
Sorry for the double post. It looks like something similar was already discussed like you mentioned.

I could combine some columns, but would rather keep some of them seperated, such as player number. I never thought of a combining formula in the spreadsheet though. Sounds like a great idea.

Thanks very much
Back to top
doggy  
#4 Posted : Monday, February 12, 2018 1:29:22 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
excel CONCATENATE function :-)
Back to top
thanks 1 user thanked doggy for this useful post.
Argo82 on 2/12/2018(UTC)
Argo82  
#5 Posted : Monday, February 12, 2018 1:38:02 PM(UTC)
Argo82

Rank: Advanced Member

Groups: Registered
Joined: 11/21/2016(UTC)
Posts: 48

Thanks: 8 times
Was thanked: 7 time(s) in 5 post(s)
Yup. Did the trick.

Thanks again.
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.090 seconds.