# How can i value data from Barcode Scanner **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [August 10, 2021, 7:30pm UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525 "2021-08-10T19:30:20Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![atilla](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/atilla/32/113139_2.png) [@atilla](https://community.thunkable.com/u/atilla)\ **Post date:** [August 10, 2021, 7:30pm UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/1 "2021-08-10T19:30:20Z")
How i can get the name when i scan the barcode with the number from google sheet? ![Bildschirmfoto 2021-08-10 um 21.26.34](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/4/d4a321e0ef81f9eb852adbe4258ad2896db684c7.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [August 10, 2021, 9:31pm UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/2 "2021-08-10T21:31:46Z")
So you want to scan the [barcode](https://docs.thunkable.com/barcode-scanner) 7649988484575 and then have the name “Dark White Amina” appear on the screen? Which blocks have you tried so far? ---
**Author:** ![bnice](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bnice/32/110648_2.png) [@bnice](https://community.thunkable.com/u/bnice)\ **Post date:** [August 11, 2021, 12:39am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/3 "2021-08-11T00:39:10Z")
Hello Atilla, Welcome to the community. Just out of curiosity, is the barcode symbolic somehow? Any extra info you can give us such as blocks tried, data needing to be retrieved, or anything like that would be much appreciated as we try to help you out. You are using Google Sheets, correct? ---
**Author:** ![hdawc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hdawc/32/119068_2.png) [@hdawc](https://community.thunkable.com/u/hdawc)\ **Post date:** [August 11, 2021, 12:47am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/4 "2021-08-11T00:47:32Z")
Hi, try this, it is an API of barcodes: Get product data for a given barcode from the [https://world.openfoodfacts.org](https://world.openfoodfacts.org) database. More info here: [https://world.openfoodfacts.org/data](https://world.openfoodfacts.org/data) There are other source that have similar information, you just need to look it up by barcode and get the title, then put that into google sheets. It’s free and the URL for the API looks like this; ```auto https://world.openfoodfacts.org/api/v1/product/[barcode].json ``` The property you (probably) want is; ```auto abbreviated_product_name there is also; product_name_en / product_name_fr etc. ``` ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 11, 2021, 7:27am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/5 "2021-08-11T07:27:17Z")
See this sample sheet ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/8/b82c9f456c716f5b42276732cbfc2f2feecbf864.png) - The first 2 columns are the data - Third column is where you will enter the BarCode number from Thunkable - The last 2 columns will show the search result Note under column 4 the function **=filter(A2:B7,A2:A7=C2)** If you enter 44 in the 3rd column then Google Sheet will automatically display the corresponding name which you can read from Thunkable. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/8/78f6a4d2308ef1c711e91fcb8ce3a002f729b0aa.png) ---
**Author:** ![atilla](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/atilla/32/113139_2.png) [@atilla](https://community.thunkable.com/u/atilla)\ **Post date:** [August 11, 2021, 7:59am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/6 "2021-08-11T07:59:21Z")
Hii Muneer thaks for this detail explain… okay but how can i show this with blocks in thunkable? ![Bildschirmfoto 2021-08-11 um 09.58.39](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8bc8b3a6b4ce653b5eca83da9027013ac09bf9ca.png) ---
**Author:** ![atilla](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/atilla/32/113139_2.png) [@atilla](https://community.thunkable.com/u/atilla)\ **Post date:** [August 11, 2021, 8:00am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/7 "2021-08-11T08:00:45Z")
Hii Tatiang yes!! I prepait a display but i dont know how i can change the label with the name scaning of barcode is working with the blocks but how i can say okay scan the barcode get the value on my google sheet search the barcode that i add and give me the name of the barcode ![Bildschirmfoto 2021-08-11 um 09.58.39](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8bc8b3a6b4ce653b5eca83da9027013ac09bf9ca.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 11, 2021, 8:32am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/8 "2021-08-11T08:32:04Z")
Using my example above, this is what I will do to test it ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/b/eb06fedd0ae191035f2510a252fdf2614353d84f.png) This is the output ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/6/060cf29e3582888e193f8853fcc3ac6a09d93ef1.png) ---
**Author:** ![atilla](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/atilla/32/113139_2.png) [@atilla](https://community.thunkable.com/u/atilla)\ **Post date:** [August 11, 2021, 8:55am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/9 "2021-08-11T08:55:14Z")
Thanks Muneer for your time!!! that works great when i type the code in the inputfield but how i can do it with scan the barcode and give the name out ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 11, 2021, 8:58am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/10 "2021-08-11T08:58:03Z")
In this block ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/d/8d05f53d3c4133bfbfff3b0f95ac7ddc41637901.png) Put the barcode number you got from the scanner instead of the `Text_Input's Text` ---
**Author:** ![atilla](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/atilla/32/113139_2.png) [@atilla](https://community.thunkable.com/u/atilla)\ **Post date:** [August 11, 2021, 9:04am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/11 "2021-08-11T09:04:44Z")
Hmm it not works … sorry i’m in this area a newbe ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/8/48b80e00c5592136b3011105f5da2911121c4229.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 11, 2021, 9:09am UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/12 "2021-08-11T09:09:42Z")
Use it this way ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/7/571b7161c9afbe9d2a08c7e72d5778ab6cf5d0b6.png) Then use the variable in the Google sheet update block. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fdc1e26ce87d23a152c3881f3ce98a063fddaf30.png) ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:17pm UTC](https://community.thunkable.com/t/how-can-i-value-data-from-barcode-scanner/1442525/13 "2024-11-08T13:17:26Z")