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

Find more posts tagged with

Attachments

Project Management

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…