Bar code scanner not capturing actual bar code only numbers/text

kristian.jochimsen

I am trying to build an inventory/stock management sheet but i cannot scan the actual bar code image into the sheet.

 

I have tried using an Iphone XR and a Samsung Galaxy S9 with no luck on wither.

 

It will only scan the numbers and/or text. I have tried over ten different bar codes on various items with no luck.

 

Please help. This is a major hurdle.

 

Thanks very much,

 

Kristian Jochimsen

Andrée Starå

Hi Kristian,

Unfortunately, it's not possible at the moment to add barcode pictures by scanning, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

As a workaround, you could use a Google Sheet solution to create the barcode images and then add those to Smartsheet.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

I have a "master inventory" sheet of sorts, and I simply attached a picture of the barcode in a column I just called "Barcode".

Andrée Starå

Yes, you can, of course, take a picture of the barcode and save that, but I think what's asked for is probably a clean barcode picture.

Good workaround nevertheless!

kristian.jochimsen

Thank all.

 

I will figure out a solution one way or another.

Andrée Starå

Happy to help!

Have a fantastic weekend!

Paul Newcome

Happy to help! 

Paul Newcome

Yes. Having the "clean" barcode displayed on the sheet would be nice. To keep things looking half decent, I have to crop and resize each of my images to make sure all of the barcodes appear to be the same size and whatnot. I ended up getting the most consistent results using the barcode "font" in Excel then using the cell outline as a guide for a snippett. My snippetts save as .png files, so I am able to easily display them in a cell in SS from there.

Andrée Starå

It's possible to automate it with the help of Goggle Sheets so you don't have to crop any pictures.

Paul Newcome

I'm going to have to dig into this. While my current system is working pretty smoothly, everything that can be automated is one less thing that I have to worry about forgetting.

Andrée Starå

Exactly!

I'll share if I find have something that you could use.

Paul Newcome

Much obliged!!

Andrée Starå

Here's an excellent resource.

https://berrywing.com/barcode/

Andrée Starå

Here's what you could use to get an EAN 128 code in Google Sheet.

=image("http://berrywing.com/barcode/Code128.aspx?bc=" & A1)

Paul Newcome

Awesome! I'll take a look.