Listpicker from google sheet

load data from google sheet, how i can do?


ListPicker.aia (3.9 KB)

thanks

Your CSV file, for reference purposes:

1,067014,(FIFO) 10224 CABLE DESIGNED IPHONE 5 
2,067015,(FIFO) 10225 CABLE MICRO DESIGNED VARIAD 6
3,067018,(FIFO) 46652 POWER BANK PORTATIL SOL
4,067020,(FIFO) 60074 CABLE 3.3 IPHONE 5 
5,067022,(FIFO) 60164 PAWER BANK  COLORES 
6,067024,(FIFO) 60207 CARGADOR DE CARRO DOBLE BLACK 
7,067025,(FIFO) 60223 AUDIFONOS FIFO VARIADO
8,067026,(FIFO) 60410 CABLE AUX 5 PIES
9,067027,(FIFO) 60411 AUDIFONO FIFO COLORES 
10,067029,(FIFO) 60415 CABLE PARA IPHONE 7 BLANCO 
11,067030,(FIFO) 60416 CABLE PARA IPHONE 7 COLORES 
12,067031,(FIFO) 60417 CABLE MICRO DE 7 PIES 
13,067032,(FIFO) 60418 CABLE MICRO 7 PIES V
14,067033,(FIFO) 60419 CABLE 7 PIES MICRO VAR
15,067038,(FIFO) 69089 CABLE MAGNETI IPHONE 5
16,067039,(FIFO)71250 CONECTOR DE CASA DESIG
17,044385,2 BIBERÓNES DE 4OZ ANTICOLICO
18,022546,2 PEZONERAS MARIPOSA MEDIUM
19,074509,2 TETINAS F1 0M NATURAL RESPONSE
20,051351,2 TETINAS F2 0M+ NATURAL RESPONSE

(more to follow)

yes

From reading and running your code, I see that you load the CSV file into a dictionary with column 3 as its keys, and as values a list of the corresponding column 2 values.

The app does that okay, aside from an awkward load into the global variable leercsv. I would have set leercsv directly to the List From CSV Table output, to skip having to operate on item 1 of that variable.

But from the title of your post, I guess you are looking for any post in

Is this your 18000 row CSV? If so, would be better to query on the Google sheet, instead of continually downloading the whole thing.

Is this what you wanted to do?