Is there a way to have Smartsheet generate a list of barcodes to print out?
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
Ricky T
Gov Contractor for USSF
Best Answers
-
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.
-
@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.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@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.
Answers
-
@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.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen Im not sure what kind, what ever is the most simple kind to be honest. Does smartsheet have an open API?
Ricky T
Gov Contractor for USSF
-
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.
-
@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.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@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.
-
@Paul Newcome YouTube is your friend 😁
The fonts are only for 1D barcodes or are the fonts able to create 2D barcodes as well?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@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.
-
@Paul Newcome we can't all hand engrave barcodes 🤣
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@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... 🤣
-
@Paul Newcome cool. I like it 😁
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
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 ?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives