vMix Forums
»
General
»
General Discussion
»
How to dynamically select the next X rows of data from Google Sheets based on selected
Rank: Newbie
Groups: Registered
Joined: 4/24/2019(UTC) Posts: 7 ![United States United States](/Content/images/flags/US.png) Was thanked: 1 time(s) in 1 post(s)
|
Is there a way to dynamically select the next two rows of data in a google sheets data source such that if I have the following.
Bobby 1pm John 2pm Sara 3pm Veronica 4pm
so, if I select in the data source manage the first row, I can also show in the title editor the one select plus one so it would look like.
Bobby-1pm Next up: John 2pm
Then when I move the selected forward to John. it would now change the title to:
John- 2pm Next Up: Sara 3pm
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,171 ![Belgium Belgium](/Content/images/flags/BE.png) Location: Belgium Thanks: 288 times Was thanked: 942 time(s) in 778 post(s)
|
Originally Posted by: sautez ![Go to Quoted Post Go to Quoted Post](/Themes/yafpro/icon_latest_reply.gif) Is there a way to dynamically select the next two rows of data in a google sheets data source such that if I have the following.
Bobby 1pm John 2pm Sara 3pm Veronica 4pm
so, if I select in the data source manage the first row, I can also show in the title editor the one select plus one so it would look like.
Bobby-1pm Next up: John 2pm
Then when I move the selected forward to John. it would now change the title to:
John- 2pm Next Up: Sara 3pm
Think the best option would be to create another sheet with extra columns added representing the next row of data and use that ![](/Themes/yafpro/icon_file.gif) Screenshot 2023-01-24 093840.jpg (25kb) downloaded 1 time(s).
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2019(UTC) Posts: 7 ![United States United States](/Content/images/flags/US.png) Was thanked: 1 time(s) in 1 post(s)
|
That would work if the data was static but I'm not entering the data. Another will be updating and changing as they need. I kind of think I may have to write some complex onEdit plus set value to new location spreadsheet.
I would like to see the ability to reference the sheet relative to what I have selected in the data source.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,171 ![Belgium Belgium](/Content/images/flags/BE.png) Location: Belgium Thanks: 288 times Was thanked: 942 time(s) in 778 post(s)
|
Originally Posted by: sautez ![Go to Quoted Post Go to Quoted Post](/Themes/yafpro/icon_latest_reply.gif) That would work if the data was static but I'm not entering the data. Another will be updating and changing as they need. I kind of think I may have to write some complex onEdit plus set value to new location spreadsheet.
I would like to see the ability to reference the sheet relative to what I have selected in the data source. above was just an example Google sheets ( just like Excel) has many ways of manipulating data ( to another sheet to be used as datasource) to what you need automatically (with the right formulas) based on what the other person is updating on the main sheet Doesnt have to be complex at all Another option is to consider converting rows to columns and select the appropriate colums to refer to instead The other option is to manipulate the data externally (app) with more control on what to send to the title but will be more complex and initial work than the above Anywy the whole point of data source use is that they dont have to have static content and can regularly update
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2019(UTC) Posts: 7 ![United States United States](/Content/images/flags/US.png) Was thanked: 1 time(s) in 1 post(s)
|
Yes agree that the spreadsheet can have a tool that updates a known row/column that I pull from. I get that, but was wonder if there was a filter/query solution from the vmix client side that I could use. Something like. {Selected +1 } that would return the row of data and I could use that was a solution. Would be a nice feature in vMix for the Titles where I could pull the selected and next X number of data with a simple "filter" or add to the "format" section. so, could be format: {[x +1] {0}] Where X is the selected row number and {0} is the contents of the column defined on that row.
I'll just fix the spreadsheet to produce a known row/column set and do selection in the spreadsheet to update.
Thanks for the suggestion.
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
How to dynamically select the next X rows of data from Google Sheets based on selected
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