# Barcode scanner

**URL:** <https://community.glideapps.com/t/barcode-scanner/18579>\
**Category:** Project Showcase\
**Created:** [November 17, 2020, 8:34pm UTC](https://community.glideapps.com/t/barcode-scanner/18579 "2020-11-17T20:34:52Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 17, 2020, 8:34pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/1 "2020-11-17T20:34:52Z")

</div>

URL: [https://barcode-scanner.glideapp.io/](https://barcode-scanner.glideapp.io/)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a08b0139d4c936f78e6db60dbfcf1b6c710a955e.png)

Created a new (very simple) barcode scanner which also scans QR code.

It makes use of service from barcodeapi from [https://cloudmersive.com/](https://cloudmersive.com/)  
This service scan an image or photo of a barcode and return the result. Supported barcode types include AZTEC, CODABAR, CODE\_39, CODE\_93, CODE\_128, DATA\_MATRIX, EAN\_8, EAN\_13, ITF, MAXICODE, PDF\_417, QR\_CODE, RSS\_14, RSS\_EXPANDED, UPC\_A, UPC\_E, All\_1D, UPC\_EAN\_EXTENSION, MSI, PLESSEY, IMB

The app makes use of two scripts (one for pulling json data from the barcode decoder and one for adding new lines in the sheet when somebody enters a new barcode)

The uploaded image by use of the image picker is sent to Cloudinary as Glide doesn’t allow to reduce file size and that is needed for the barcode decoder service.

**Notice**

- create your own cloudinary account (the app is using my account) if you want to experiment with numerous barcodes.
- create your own free cloudmersive account (800 call/month) if you want to do your own experiment with the service
- don’t upload personal or sensitive data to the app
- uploaded barcodes images will be deleted with regular intervals as they cannot be fetched into a folder in Cloudinary - so my account will get messy 🤪

Please make sure that images can be fetched (see below)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e03fb2b0867e9c79bf30e2ad881d932c0cd10c01.png)

If you want to do your own experiments I made a copyable app here:

> **[Barcode scanner template](https://barcode-scanner-temp.glideapp.io/)**

Your must make the fillFormula script run onChange  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15bd61078ad003f0596b86eef0965ca42bb9b3d3.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d13f5034db6ae102f221bc6b6e218faeabb10e8.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94635172f8cfd3fb4d0860cd38378ff9aaa31086.png)

**Thanks to:**  
@Darren_Murphy for helping out getting the google script do Post operation 👏 👏  
@ThinhDinh for helping with script to copy line with importjson 👍 👍

The app can be thought of a further development of the QR demo scanner:

> [@QR code scanner demo](https://community.glideapps.com/t/qr-code-scanner-demo/11620):
>
> URL: [https://qrcode.glideapp.io/](https://qrcode.glideapp.io/) There a been a number of posts regarding QR code scanner functionality. A native Glide QR code scanner would be very beneficial - so this app is just a kind of workaround. @Zhijing_Eu made a great presentation earlier on (and I forgot which service he used so I started a search for a QR code decoder myself and ended up with the same as him crazy_face ) Inspiration was also coming from this thread The app makes use of two scripts (one for pulling…

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 17, 2020, 8:43pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/2 "2020-11-17T20:43:00Z")

</div>

Hi Kristian 👋🏻 I tried your app, and I have no idea what I’m doing 😂

So I uploaded a bar code (found on the back of a book). Now what?

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 17, 2020, 8:46pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/3 "2020-11-17T20:46:14Z")

</div>

@nathanaelb Well, nice EAN\_13 code your book got. Would you like the app to order a new book for you 🤪

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 17, 2020, 8:53pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/4 "2020-11-17T20:53:10Z")

</div>

I obviously don’t understand what the service is meant to do, sorry 🙈

So I scan my bar code and I notice the app returns the bar code number. Also, in my example, what does EAN\_13 stand for?

I’m trying to visualize use cases.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 17, 2020, 9:04pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/5 "2020-11-17T21:04:33Z")

</div>

@nathanaelb I thought this was clear - but obviously it wasn’t 😑

The app can scan a number of different types of barcodes amongst other QR code, UPC, EAN\_13 etc.  
It will return the information found in the barcode.

> **[International Article Number](https://en.wikipedia.org/wiki/International_Article_Number)**
>
> The International Article Number (also known as European Article Number or EAN) is a standard describing a barcode symbology and numbering system used in global trade to identify a specific retail product type, in a specific packaging configuration, from a specific manufacturer. The standard has been subsumed in the Global Trade Item Number standard from the GS1 organization; the same numbers can be referred to as GTINs and can be encoded in other barcode symbologies defined by GS1. EAN barcodes...

In your case it is simple to read the code - but you can now import the data into your google sheet - and use it for what ever. For QR code you can - as you know - embed an url which is great for redirecting to a website.

If the scanning process was quicker then you could use it for counting your shop inventory

I wonder if that makes sense?

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 17, 2020, 9:12pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/6 "2020-11-17T21:12:24Z")

</div>

I understand! I had never really given any thought to what bar codes were. Now I know the image represents a string of digits.

So indeed, as the name of your app suggests, your app scans bar codes or QR codes, and in the case of the bar code returns the bar code number.

Very clear from the beginning. I’ll remember this, thanks!

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 17, 2020, 10:17pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/7 "2020-11-17T22:17:31Z")

</div>

@nathanaelb If you use a service like [https://www.upcitemdb.com/api/explorer#!/lookup/post\_trial\_lookup](https://www.upcitemdb.com/api/explorer#!/lookup/post_trial_lookup)  
then you can get information about the item that you have scanned:  
[https://api.upcitemdb.com/prod/trial/lookup?upc=9788866320326](https://api.upcitemdb.com/prod/trial/lookup?upc=9788866320326)

```
{
  "code": "OK",
  "total": 1,
  "offset": 0,
  "items": [
    {
      "ean": "9788866320326",
      "title": "L'amica Geniale - Paperback / Softback Ferrante, Elena 29/10/2011",
      "description": "",
      "isbn": "9788866320326",
      "publisher": "E/O",
      "category": "Media > Books",
      "images": [
        "http://www.alibris.com/images/elements/no_image.gif",
        "https://i13.onbuy.com/product/39167a5718714c3b8210d15fe53bf499-l1275444.jpg"
      ],
      "offers": [
        {
          "merchant": "Alibris",
          "domain": "alibris.com",
          "title": "L'Amica Geniale",
          "currency": "",
          "list_price": "",
          "price": 35.51,
          "shipping": "",
          "condition": "New",
          "availability": "",
          "link": "https://www.upcitemdb.com/norob/alink/?id=03v263t2y2z2a4d4&tid=3&seq=1605651205&plt=9a1284665db73a9c54cfcc6134ee5de3",
          "updated_t": 1413416097
        },
        {
          "merchant": "OnBuy.com",
          "domain": "onbuy.com",
          "title": "L'amica geniale",
          "currency": "GBP",
          "list_price": "",
          "price": 18.86,
          "shipping": "",
          "condition": "New",
          "availability": "",
          "link": "https://www.upcitemdb.com/norob/alink/?id=u2x233132343e454s2&tid=3&seq=1605651205&plt=27f63588ffb41c8133e820351f2e7ddf",
          "updated_t": 1571464729
        }
      ]
    }
  ]
}
```

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 17, 2020, 11:00pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/8 "2020-11-17T23:00:17Z")

</div>

That’s brilliant!

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 18, 2020, 9:19am UTC](https://community.glideapps.com/t/barcode-scanner/18579/9 "2020-11-18T09:19:19Z")

</div>

Very neat: from smart simple picture to bar code number to product information.

---

<div class="post-metadata">

**Author:** ![F\_rank](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/f_rank/32/30511_2.png) [@F\_rank](https://community.glideapps.com/u/F_rank)\
**Post date:** [November 18, 2020, 12:22pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/10 "2020-11-18T12:22:28Z")

</div>

Oh cool maybe that’s what I need for my app.

I want to scan a product in real life and then it links to the product in the google sheet. Something like that:

https://player.vimeo.com/video/480733892

Would it be possible?

---

<div class="post-metadata">

**Author:** ![abhilashabhatia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abhilashabhatia/32/10618_2.png) [@abhilashabhatia](https://community.glideapps.com/u/abhilashabhatia)\
**Post date:** [November 18, 2020, 1:28pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/11 "2020-11-18T13:28:39Z")

</div>

This is very cool use case @Krivo!

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 18, 2020, 9:03pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/12 "2020-11-18T21:03:24Z")

</div>

@F_rank I cannot see it is directly possible as you would like to go to details just after you scanned the barcode.

I have made an example that looks a bit what you want.

> **[Barcode scanner store](https://barcode-shop.glideapp.io/)**

When we got compound ation where some actions are not fired until a form have been completed then I expect that you do something very similar to what you want.

Try to scan the following barcode - and see the result

https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/uRk7wjazZGYLrFHSjmHJ/pub/D6awYYyEHqNdoRtunNkp.jpg

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d79879d8c0ce738e10147899137629d9917438c5.jpeg)

---

<div class="post-metadata">

**Author:** ![leandro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leandro/32/16780_2.png) [@leandro](https://community.glideapps.com/u/leandro)\
**Post date:** [November 19, 2020, 3:27pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/13 "2020-11-19T15:27:21Z")

</div>

Muito legal, mas infelizmente ate o momento o glide não dispõe de nenhum componente com função QR code

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [November 19, 2020, 4:07pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/14 "2020-11-19T16:07:56Z")

</div>

Awesome 🕶 you always deliver something special. Last time it was QR codes and bow barcodes. 👍👍👍

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [November 19, 2020, 4:14pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/15 "2020-11-19T16:14:02Z")

</div>

## Simply awesome!!!

---

<div class="post-metadata">

**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\
**Post date:** [November 19, 2020, 7:25pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/16 "2020-11-19T19:25:00Z")

</div>

Hi it is very well app thanks. I just try to read QR. How can I read a QR code with scanning?

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 19, 2020, 7:38pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/17 "2020-11-19T19:38:39Z")

</div>

@Bahadir_Kaya I’m not sure what you are asking. If you click on scan barcode then you can upload an image and it will tell you what the QR code includes

---

<div class="post-metadata">

**Author:** ![raghav\_khandelwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raghav_khandelwal/32/12492_2.png) [@raghav\_khandelwal](https://community.glideapps.com/u/raghav_khandelwal)\
**Post date:** [December 8, 2020, 7:13am UTC](https://community.glideapps.com/t/barcode-scanner/18579/18 "2020-12-08T07:13:02Z")

</div>

What I just found in Staging 😉

:

 ![Bar code](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e8aecb0b1bd00e7361236ff4564cf13eccaad68.png)

---

<div class="post-metadata">

**Author:** ![THIBAULT\_Drd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_drd/32/15051_2.png) [@THIBAULT\_Drd](https://community.glideapps.com/u/THIBAULT_Drd)\
**Post date:** [December 8, 2020, 1:02pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/19 "2020-12-08T13:02:48Z")

</div>

@raghav_khandelwal Hi, where did you find this?

---

<div class="post-metadata">

**Author:** ![raghav\_khandelwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raghav_khandelwal/32/12492_2.png) [@raghav\_khandelwal](https://community.glideapps.com/u/raghav_khandelwal)\
**Post date:** [December 8, 2020, 1:13pm UTC](https://community.glideapps.com/t/barcode-scanner/18579/20 "2020-12-08T13:13:11Z")

</div>

Currently in Staging. Might take some time to have this in production.

[Next page](https://community.glideapps.com/t/barcode-scanner/18579.md?page=2)