Profile

Matt Finlayson

Contact Details

My Content

1 to 20 of 26 total

Datalinq table and Google Sheets

Posted By Matt Finlayson 10-24-2024 13:45
Found In Egroup: Graphics \ view thread
I am familiar with using Excel Spreadsheets to pull data from Tables. The Table field in datalinq would look something like this: SELECT [COLUMN] FROM [TABLE NAME] WHERE [JERSEY] = @playernumber@ I am trying to accomplish the same thing with Google Sheets and while I can get the datalinq to ...

RE: Increasing Datalinq Reference Number

Posted By Matt Finlayson 06-21-2024 12:07
Found In Egroup: Graphics \ view thread
Hi John, I can tell you how I'm doing it, but as you know, there is more than one way to skin a phoenix. First, I have a datalinq key in my scene named "idx". The value is set to max. This will ensure I pull the most recent drive data. I also use the datalinq key to pull the previous drive data, ...

RE: Pause an XPression Group from DashBoard using RossTalk

Posted By Matt Finlayson 03-07-2024 11:54
Found In Egroup: Graphics \ view thread
Hey Ethan- I have that same scenario in my XPression Tessera. I've used the solution that Garner suggested, which is a perfectly valid solution. I was going to share another option, but it would probably require more help setting up than can be shared in this message. Good luck. ------------------------------ ...

RE: Referencing an Excel Row via a Column

Posted By Matt Finlayson 01-30-2024 12:51
Found In Egroup: Graphics \ view thread
Try putting Name in brackets. SELECT [Name] FROM [blade_election... ------------------------------ Matt Finlayson Brigham Young University ------------------------------

RE: Referencing an Excel Row via a Column

Posted By Matt Finlayson 01-30-2024 12:04
Found In Egroup: Graphics \ view thread
I am on version 11.5, but I believe I first started using this at version 10 or 10.5. I should've mentioned that "WHERE [JERSEY] =" section is referencing the column name of the player number. In my case, the Excel column is called "JERSEY". Yours may be different. ------------------------------ ...

RE: Referencing an Excel Row via a Column

Posted By Matt Finlayson 01-30-2024 10:50
Found In Egroup: Graphics \ view thread
Hi John, I am attaching a screenshot of how I have datalinq from Excel set up for my baseball stats. Column = the name of the column exactly how it appears in your spreadsheet. Row = 1 (always) Table = SELECT [should match the column field above] FROM [name of table your pulling stats from in Excel] ...

RE: Parsing Text with Comma

Posted By Matt Finlayson 12-30-2023 15:14
Found In Egroup: Graphics \ view thread
Thanks for the help. I will try this script. My original script seems to be working now, after a reboot of everything. (Which is what I should’ve done before requesting the help) However, I will know more after tonight’s game to see if the script holds true. Matt Finlayson

Parsing Text with Comma

Posted By Matt Finlayson 12-29-2023 16:59
Found In Egroup: Graphics \ view thread
There is a recent post about parsing text via scripting. I have a similar question, but my issue is a bit different. I am pulling a name from datalinq. Ex. STEWART,TREY Here is the script I am using on the text object to delete the first name and just show the last name: dim list(3) as ...

RE: Excel Datalinq data missing

Posted By Matt Finlayson 04-20-2023 11:00
Found In Egroup: Graphics \ view thread
I'm not sure how to directly address address your problem, but I will say that I have been using .xls docs for data for a long time and have just recently started having compatibility problems where the file won't save correctly and other issues. So I switched to .xlsx documents. I was told that as long ...

RE: Script running scene directors

Posted By Matt Finlayson 02-22-2023 19:12
Found In Egroup: Graphics \ view thread
Mal and Red, I can't thank you enough for your expertise and suggestions. I was able to get it working the way I intended thanks to your help. Here's what it looks like: https://byu.box.com/s/cfiwxuugg8e4h6wjhtalp128qtuz7ie1 ------------------------------ Matt Finlayson Brigham Young ...

RE: Script running scene directors

Posted By Matt Finlayson 02-22-2023 13:45
Found In Egroup: Graphics \ view thread
Do you mind sharing your Dashboard grid with me? I'm curious how you've set it up. My Dashboard has some intricacies that I don't want to break if I make changes. Thanks. ------------------------------ Matt Finlayson Brigham Young University ------------------------------

RE: Script running scene directors

Posted By Matt Finlayson 02-22-2023 13:03
Found In Egroup: Graphics \ view thread
Thanks, Red. I appreciate the suggestion. I created a hilite control text object and applied the script to OnSetText. I was able to get the scene to work if I were to type in number 1-9 in the template data and hit Take. My challenge now is how to populate that text object with a number and to run while ...

RE: Script running scene directors

Posted By Matt Finlayson 02-21-2023 23:44
Found In Egroup: Graphics \ view thread
I'm not sure how I would change the text value on a single hidden text object. However, I have 9 hidden text objects which receive a 0 or 1 based on whether or not the checkbox in Dashboard is active or not. Your suggestion got me thinking that maybe I could have each of those have an OnSetText script. ...

RE: Script running scene directors

Posted By Matt Finlayson 02-21-2023 23:13
Found In Egroup: Graphics \ view thread
Here's the dashboard and a screenshot of the dashboard. The yellow box highlights the checkboxes that I use to indicate current player at bat. This is datalinqed with the "at bat data" in the Xpression scene. If I put the script in OnOnline, it will only run an animation when the scene goes from offline ...

RE: Script running scene directors

Posted By Matt Finlayson 02-21-2023 22:35
Found In Egroup: Graphics \ view thread
Leave it to a Ute to sabotage BYU. �� Just kidding. Thank you for your help. Matt Finlayson Manager, Live Event Content Creation BYU AV 301.332.6626 Cell 801.422.0180 Office 1030B ITB

RE: Script running scene directors

Posted By Matt Finlayson 02-21-2023 22:27
Found In Egroup: Graphics \ view thread
Same results, unfortunately. Matt Finlayson Manager, Live Event Content Creation BYU AV 301.332.6626 Cell 801.422.0180 Office 1030B ITB

RE: Script running scene directors

Posted By Matt Finlayson 02-21-2023 22:12
Found In Egroup: Graphics \ view thread
Thanks for the quick reply, Mal. Great suggestion. Still doesn't seem to be working for me. The scene directors play fine when I play sequentially. I can go from batter 3 to 4 or from 4 to 7, but not if I want to go from batter 3 to batter 2 or 1. Or batter 9 to 1. I adjusted the script to include the ...

Script running scene directors

Posted By Matt Finlayson 02-21-2023 19:52
Found In Egroup: Graphics \ view thread
I have an Xpression scene with a batting order. I have an Object that highlights each batter as we move through the lineup. There is an individual scene director for each change from batter 1 to 2, 2 to 3, etc. The below script works from batters 1 to 9. What I can't figure out is why I can't get the ...

RE: DashBoard Text Field Updates Xpression Clock Timer Widget

Posted By Matt Finlayson 10-07-2022 16:58
Found In Egroup: Facility Control \ view thread
Hi Nick, Did you ever get the steps to option 2? If so, can you share? I have a similar scenario. I want the Dashboard operator to enter the time in a text field and then click a button that starts the countdown. I am using a Clock parameter in Dashboard at the moment, but it seems to be limited to ...

RE: Using Google Sheets for real-time data

Posted By Matt Finlayson 06-16-2022 08:35
Found In Egroup: Graphics \ view thread
I tried the pdf just now, out of curiosity, without success. Looks like the Sheets v3 API has been turned down. I'm commenting on this thread so that I get notified, in case someone knows how to use Google Sheets in 2022. ------------------------------ Matt Finlayson Brigham Young University - ...