Is there a way to have Smartsheet generate a list of barcodes to print out?

RickyT

I need to make the labels for an inventory sheet and wanted to see if smartsheet could generate a sheet of them and I can print them out. I need to do it for 4-5 thousand labels

Paul Newcome

Smartsheet does have an open API depending on your account level, but you can also do this very simply in Excel. You can get multiple barcode "fonts" in Excel which would allow you to enter the alphanumeric string flanked by asterisks then just select a different "font". There are a number of different places you can go to download the barcode font.

Darren Mullen

@RickyT @Paul Newcome Yep you can do that in Excel or Google Sheets. With Google Sheets you can use the Google chart API to create 2D barcodes as well!

The Google chart API should probably work in Excel, especially if you are using Excel online.

Paul Newcome

@Darren Mullen Not all of us are able to create our own APIs though (learning but not there yet). Haha.

The "font" in Excel is MUCH easier for me personally.

Darren Mullen

@RickyT are you looking to generate 1D or 2D barcodes?

There are ways to do this but would require doing it over the API. I know of an add-on that does this for 2D barcodes, I'm confirming if it will also generate 1D as well.

RickyT

@Darren Mullen Im not sure what kind, what ever is the most simple kind to be honest. Does smartsheet have an open API?

Paul Newcome

Smartsheet does have an open API depending on your account level, but you can also do this very simply in Excel. You can get multiple barcode "fonts" in Excel which would allow you to enter the alphanumeric string flanked by asterisks then just select a different "font". There are a number of different places you can go to download the barcode font.

Darren Mullen

@RickyT @Paul Newcome Yep you can do that in Excel or Google Sheets. With Google Sheets you can use the Google chart API to create 2D barcodes as well!

The Google chart API should probably work in Excel, especially if you are using Excel online.

Paul Newcome

@Darren Mullen Not all of us are able to create our own APIs though (learning but not there yet). Haha.

The "font" in Excel is MUCH easier for me personally.

Darren Mullen

@Paul Newcome YouTube is your friend 😁

The fonts are only for 1D barcodes or are the fonts able to create 2D barcodes as well?

Andrée Starå

Hi @RickyT

I hope you're well and safe!

Is this a one-time thing or something recurring?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Darren Mullen I have only ever needed 1D. I have honestly never looked to see if there is a font download out there for 2D.

I use it to create barcodes for metal tags on things like chainsaws and other tree service related equipment. If I take my time, I can hand engrave a 1D much easier than a 2D and save myself a little bit of money. Haha.

Darren Mullen

@Paul Newcome we can't all hand engrave barcodes 🤣

Paul Newcome

@Darren Mullen I see what you did there, Haha.

That came out of necessity. Haha. A sheet of metal, an angle grinder, a stencil of the barcode, and a rotozip is cheaper than having to keep ordering custom metal tags online. Especially when I already have all of that laying around the workbench anyway. I fill it in with black sharpie and then apply a thin coat of resin over the top to protect it from scratches, bumps, oil, dirt, water, etc..

It is not pretty, no where near as neat/square, and definitely a bit larger than custom ordered, but it gets the job done for a lot less money. One of these days I'll have a cnc machine that I can program to just do the engraving for me. Until then... Terrible tracing with power tools will have to do... 🤣

Darren Mullen

@Paul Newcome cool. I like it 😁

MaaikMeijerink

Hi @RickyT

Did you have a look at the QR generator: https://www.smartsheet.com/marketplace/apps/inline-qr-generator

Perhaps this can help you out ?