Search info into .csv file, Modific & Save

djafter · October 19, 2020, 1:36am

Hi guys !

Please, Im trying use DB with csv file, for example:

In the app I put the ID in Textbox, and the info : Name, Car and Color is show in labels.

Any idea ?..How can i show the name, car and color in the labels ?
im not problem with download csv file to phone or use airtable, I not need show list.
I read several post & messages, but almost all of them talk about showing the information in lists or tables, I only need to show it in labels when pressing the search button.

Please, Im sorry for my bad english. Thx u in advanced !

The_K_Studio · October 19, 2020, 2:01am

Use

Get Row block from airtable spreadsheet.

After got row, show it in your labels.

djafter · October 19, 2020, 2:14am

Dear, but what is the row number ?
How can i search in airtable the ID typed in text box?

The_K_Studio · October 19, 2020, 2:24am

First get column of ID by using column name.

Then use get index of thing (ID) in column list.

Using this index as row number get row.

djafter · October 19, 2020, 2:34am

Sorry, i not understand where make match of ID typed and ID of Row
With a list is posible select id row, but i not need show listview.

The_K_Studio · October 19, 2020, 2:49am

Now in got column block,

Set get row block, set row id to index of thing in list block and set thing to ID of which row you want to get and set list to values

djafter · October 19, 2020, 2:58am

I need a global list?

Im sorry…I want to pull my hair out !!

The_K_Studio · October 19, 2020, 3:01am

You can also set cloumn values to global list for later use.

djafter · October 19, 2020, 3:03am

Im sorry
this is really frustrating !
finally I would like to know if you can help me with an image of the blocks

The_K_Studio · October 19, 2020, 3:37am

0753×499 45.3 KB

djafter · October 19, 2020, 4:01am

Thx u for your help !
Now i have a sunshine !

I try change any blocks… why ? the result is all Row, for example using ID : 12345
-Result name (or label1) = Maximun Prada 1 Blue

The_K_Studio · October 19, 2020, 4:06am

Now you can try, select list item to separate each row value and show it in labels.

djafter · October 19, 2020, 4:12am

jejejeje Im sorry for my bad english:

For the block made for you.
When . Got row put the info to Label1 ( Using index in list thing :12345 ), the result is all Row ( Maximun Prada 1 Blue ) in the Label1.
the correct thing would be just the name ( Maximun Prada )

Label1 = Maximun Prada
Label2 = 1
Label3 = Blue