Graphics

Hi,

I'm using an ADODB datasource (Excel spreadsheet) for linking my lowerthird stats. I'm using a datalinq key called jersey and I've inserted that as the row reference on my datalinq tab. In the sequencer I've added a %relid% macro to my datalinq key field and seemingly it works fine. The group ID (100) is subtracted from the Take ID (101) and the first lower third gives me row one in my spreadsheet, the second lower third gives me the second line and so on...

However, this means that the jersey number have too be the same as the row number in my Excel table, which is hard when it comes to icehockey. I have a 25-man roster with random numbers between 1-100. Take ID 184 should give me the player with jersey number 84, not row 84 in the table. Have I completely misunderstood here, or am I doing something wrong? If this is to work with fast recall the way it should I have to have player 84 on row number 84 in my excel spreadsheet?

Btw, I've already seen all the videos on this topic and I can see that the trainer uses the same jersey number as the row number, but this won't be the case in almost any roster in any sport. Teams usually dont have players from 1-25, but have more random numbers and might skip a few..

T

Hello,

I had this same issue with a recent church conference I worked. I also used an ADODB datasource (Excel spreadsheet) with apx. 2000 delegate names. I would recall the delegates by their assigned delegate ID number - i.e. 0086, 0087, 0088, etc.
The spreadsheet was numerically listed, however, sometimes there would be a large gap with no numbers. For example, the spreadsheet would jump from Delegate# 1102 to 1120. I ended up spending an hour or two just inserting blank rows inbetween the gaps to ensure that Delegate# 1120 was on spreadsheet-row 1120, not 1103.

Did you ever find a solution to this problem?

Thank you.
#XPression

Bump. I would also like to know the answer to this. Seems a little cumbersome (and time consuming) to do it this way.
#XPression

You should be able to add a SELECT statement to the Datalinq'd text object in "Table:". This is what it could look like for PLAYER_NAME, for example: "‹SELECT [PLAYER_NAME] FROM PLAYERS WHERE [JERSEY_NUM] = %Jersey%
#XPression