vMix Forums
»
General
»
General Discussion
»
Map Datasource to Title using Script
Rank: Newbie
Groups: Registered
Joined: 2/4/2025(UTC) Posts: 4  Thanks: 2 times
|
Hey everyone,
I have some big titles in my production with a lot of fields to be populated. The datasource to be used is a google sheet. I used to manually assign the title's fields to the corresponding cells of the sheet. That works perfectly, however it takes a lot of time to assign the fields by hand and it is very error prone.
I would like to assign the cells of the datasource via a VB.NET script. I thought this would be a very easy task to do with a script but didn't find a way to do it. Basically I want to set row and column inside of the sheet for every field in my title.
I don't want to read out the sheets data and set the title's text, I only want to assign the corresponding rows and columns.
Any help would be appreciated, thanks in advance :)
Best regards
Felix
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,304  Location: Belgium Thanks: 296 times
Was thanked: 974 time(s) in 807 post(s)
|
Originally Posted by: FelixS  Hey everyone,
I have some big titles in my production with a lot of fields to be populated. The datasource to be used is a google sheet. I used to manually assign the title's fields to the corresponding cells of the sheet. That works perfectly, however it takes a lot of time to assign the fields by hand and it is very error prone.
I would like to assign the cells of the datasource via a VB.NET script. I thought this would be a very easy task to do with a script but didn't find a way to do it. Basically I want to set row and column inside of the sheet for every field in my title.
I don't want to read out the sheets data and set the title's text, I only want to assign the corresponding rows and columns.
Any help would be appreciated, thanks in advance :)
Best regards
Felix The very old "trick" is to name the column headers the same as the title text fields (according the vMix User Gude ;-) ) and use the "Auto" option
|
 1 user thanked doggy for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/4/2025(UTC) Posts: 4 Thanks: 2 times
|
Thanks for the reply, I will try that.
But what about the rows? Do I still have to assign them manually or is there also some "auto" way of doing this?
My problem is the data is scattered around the sheet but I try to bring it to standard table form.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,304 Location: Belgium Thanks: 296 times
Was thanked: 974 time(s) in 807 post(s)
|
Originally Posted by: FelixS Thanks for the reply, I will try that.
But what about the rows? Do I still have to assign them manually or is there also some "auto" way of doing this? Whenever you select a row *within the datasource or using shortcut functions) all its data that is linked to a title (column) will show their content from that row have you watched the mutliplt vMix tutorial videos regarding titles and datources ? Quote:My problem is the data is scattered around the sheet but I try to bring it to standard table form. seems a reorganisatoion of the datatable is in order. If there is some logic to the scatter a script could convert it into a more suitable table
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Map Datasource to Title using Script
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
