logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
DataSourceSelectRow and Dynamic Value - How to reference
Options
Go to last post Go to first unread
Previous Topic Next Topic
nowski  
#1 Posted : Monday, January 2, 2023 8:07:27 PM(UTC)
nowski

Rank: Advanced Member

Groups: Registered
Joined: 8/5/2017(UTC)
Posts: 135
Location: UK

Thanks: 15 times
Was thanked: 11 time(s) in 9 post(s)
Hi, I'm using a MIDI shortcut note ON to SetDynamicValue=2
Then Midi note OFF (same note) tp DataSourceSelectRow= MYDSN,Sheet1,Dynamic4

But this does not work, it appears that you cant use the Dynamic variable in this way, unless I am doing something wrong?

Thanks
Back to top
WWW

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
vmixgreg  
#2 Posted : Monday, January 2, 2023 8:38:02 PM(UTC)
vmixgreg

Rank: Staff

Groups: Registered, Moderator
Joined: 8/15/2017(UTC)
Posts: 58
Location: Canada

Thanks: 1 times
Was thanked: 17 time(s) in 16 post(s)
@ nowski

"Dynamic4" is not going to be recognized as an "index" value for your Data Source row, this needs to be an actual number starting at "0" that corresponds to the row your desired data is in, so in other words, not variable with the Dynamic Value feature in vMix.


vMix Greg
Back to top
doggy  
#3 Posted : Monday, January 2, 2023 8:40:08 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: nowski Go to Quoted Post
Hi, I'm using a MIDI shortcut note ON to SetDynamicValue=2
Then Midi note OFF (same note) tp DataSourceSelectRow= MYDSN,Sheet1,Dynamic4

But this does not work, it appears that you cant use the Dynamic variable in this way, unless I am doing something wrong?

Thanks


MYDSN,Sheet1,Dynamic4 is a string , cant combine the first part of the string with the value of the DynamicValue within the shortcut value part
In scripting you will need to pull the dynamic value first and convert it to a string to add to the "MYDSN,Sheet1," part

Has been mentioned in this forum for sure

Specifying SetDynamicValue4=MYDSN,Sheet1,2 then DataSourceSelectRow=Dynamic4 will work to
btw need to specify which Dynamic value one is setting too
Back to top
thanks 1 user thanked doggy for this useful post.
nowski on 1/2/2023(UTC)
nowski  
#4 Posted : Monday, January 2, 2023 11:14:12 PM(UTC)
nowski

Rank: Advanced Member

Groups: Registered
Joined: 8/5/2017(UTC)
Posts: 135
Location: UK

Thanks: 15 times
Was thanked: 11 time(s) in 9 post(s)
Yes thanks, figured it out eventually, but now trying to search a string value in a dynamic value, it appears that InStr(string, substring) not supported?
Or is it another example of my ineptitude.
Trying to test for characters in the Dynamic4 variable....
Back to top
WWW
doggy  
#5 Posted : Tuesday, January 3, 2023 1:11:02 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: nowski Go to Quoted Post

Trying to test for characters in the Dynamic4 variable....


vb.net !!

Try this
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.084 seconds.