How can I select a List View item by scanning a QR code that takes the reference from my spreadsheet?

General Discussion
1

I have created an inventory application in mit app inventor 2 where when I open a window with a list viewer I get a list of products from an inventory (column b), when I select one of those products I have several fields where I get information about those products, this information is collected from a Google spreadsheet. In the same application I want to put a button to scan a BIDI code (the BIDI will contain product reference numbers), because I want that when reading that number (it would be column 1 of the spreadsheet) the product is automatically selected in the list viewer

I hope to find the solution and thank you

2

You could do sth like this with the BarcodeScanner Component:

IMG_0940
IMG_09401258×947 122 KB

You just need to change the ListView items (and the way „result“ is processed) so it fits your system.
If you have further questions, feel free to ask

1 Like
3

We need to see sample data sheets and your code.

In the meantime, search this board for Marathon for a sample spreadsheet app

1 Like
4

I have a list of objects in the listview that when selecting any object it takes all the information in a spreadsheet of said object, I want to get that when I press the QR button on the left it scans the QR (which will be numbers) and said number that will be in column 1 of the spreadsheet, sends the order of which row to automatically select in my List View

Mit2
Mit2838×944 153 KB

Mit 3
Mit 3576×1280 37.2 KB

Mit
Mit1123×1299 240 KB

5

I show you what I want to do in my project

6

I can't read French.

Do you have an English version?

7

Sorry, I didn't realize I left it in my language, I'll leave it in English. Thank you very much indeed.

Mit4
Mit4949×1171 188 KB

8

Which column has the BIDI code?

And why not just download the entire sheet at startup, and keep it in a global table for query by list filter blocks?

1 Like
9

The QR code is in column G which I have not shown (seventh column). I don't know if the QR code is necessary, my intention is that when it reads the QR code which will contain numbers (1,2,3,4,5,6,7...), it associates that number with column 1 and automatically selects the product in the list of views.

10

I show you what I want to do in my project

11

I am still unclear about your difficulties.

I notice in your posts you keep mentioning storing lists in ListViews.

Those are very limited places to store data, just as buffet tables are poor storage for food.

Study the relational data model and SQL concepts, then look at the filter capability in table lookup and spreadsheet blocks.

1 Like
12

Thank you very much for the information, I will study the sections you posted since I am very new to this.