First shot at spreadsheet usage⁠›››

Guys I apologize if this has been answered before I did a search and did not find my solution.

I created a very simple csv with 2 columns CarNumber and Color Text.

The unique ID set for the spreadsheet was CarNumber. I then added a label drawing from the csv displaying Color text.

Problem is it only displays the first row as a result. Not sure what I am missing here.

Thanks,
Harold

View image on i.imgur.com
View image on i.imgur.com
View image on i.imgur.com

There are two ways to use spreadsheet bindings:

1. Use the spreadsheet as a Data Set (this is what you seem to have done). In this case, you can use a ticker to display all rows in a spreadsheet. A single label will only ever show the first item, you'll need a ticker to show the rest.

2. Use any other "session result" Data Set (followed, standings, qualification, etc). When you have a spreadsheet linked up in the theme, the list of available data bindings will now include a list of all spreadsheet columns (look at the bottom of the list). These are now linked up to the correct result via the identifier you selected.

It looks like you want to use use-case 2.

Nick,

This test sheet was to be used with the widget in Follow mode.

With a car selected I want to return the value of color as a label.

In this case the car number is to assign which row to use.

Thanks,
Harold

Yes, so you need use case 2. In the widget use the followed data set (not the spreadsheet), and replace the label data binding with the spreadsheet column binding. There should be a binding at the bottom called "test csv.Color Text"

Nick,

Thanks all good now.