Barcodes and UPC's

Samuel Courtney · 08/28/21

Consider this a giant bag of worms that I am opening!

I am interested in how others are using the Mobile App for UPC's and Barcodes. We are using it for a basic search function, but I am interested to hear about (or maybe even see) how you are applying this to more advanced business functions or maybe even customer integrations.

Pictures / Screenshots are completely welcome! Thanks In Advance

Paul Newcome · 08/30/21

QR Code to a portal. I forgot about that one. I once built out a library solution where people could scan a QR code to be taken to a portal where they were able to search for books based on author, genre, and a handful of other criteria. The search results included the book's location then they had the ability to sign books in or out as well.

Paul Newcome · 08/30/21

I personally use it for equipment tracking. If it is being checked in to or out of one of two locations (storage or maintenance shop), the barcode on the equipment gets scanned and a QR code either at the storage or maintenance shop gets scanned. When they get to a job site and when they leave a job site, they scan the barcode on the equipment and use the GPS feature to log the location.

I then use formulas to pull the most recent entry for each piece of equipment into a master so that I can very quickly see at a glance exactly where everything is.

I have also seen a case recently where managers were scanning a QR code on their employees' IDs as a way of clocking them in and out.

Andrée Starå · 08/30/21

Hi @Samuel Courtney

I hope you're well and safe!

Some of the client solutions I've developed, use it for:

Measuring time for specific steps in a process, Start/Stop (Project Sheet with QR Codes in Google Sheets that are unique for each project)
Inventory Management (check out/in)
Service/Order Request Form (using the URL-Query feature to connect it to a specific machine)
Open a Client Portal
Customer Complaints, Review, Suggestions
and more...

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Samuel Courtney · 08/30/21

Hi Andree, can you explain more about using the QR Code? I am more interested in that.

We also manage some consumer products for our customers. Trying to figure out how to create some search and management functions

Paul Newcome · 08/30/21

QR Code to a portal. I forgot about that one. I once built out a library solution where people could scan a QR code to be taken to a portal where they were able to search for books based on author, genre, and a handful of other criteria. The search results included the book's location then they had the ability to sign books in or out as well.

Samuel Courtney · 08/30/21

@Paul Newcome That is great insight. Was the portal also built with smartsheet? (Dashboard Maybe?) or did you build something external.

Paul Newcome

Aug 30, 2021

QR Code to a portal. I forgot about that one. I once built out a library solution where people could scan a QR code to be taken to a portal where they were able to search for books based on author, genre, and a handful of other criteria. The search results included the book's location then they had the ability to sign books in or out as well.

Paul Newcome · 08/31/21

It was a Dashboard in Smartsheet with forms and a report. Basically you would fill out a form with your search criteria. The form would bring you back to the dashboard where the report showed the results filtered from the master sheet. There were also forms on that same dashboard to check in/out books.

I wanted to give each book its own QR code or barcode to ensure there were no typos when checking in/out a book, but some of the books were very old and we didn't want to risk damaging them. We have been discussing other options such as barcodes for most of the books and contacting the librarian to check in/out any of the books that didn't have barcodes.

Additionally, we had a dedicated tablet so that even those without a smartphone could take advantage of it and it gave the library a central location to manage everything via a separate sign-on.

Samuel Courtney · 08/31/21

Paul Newcome

Aug 31, 2021

It was a Dashboard in Smartsheet with forms and a report. Basically you would fill out a form with your search criteria. The form would bring you back to the dashboard where the report showed the results filtered from the master sheet. There were also forms on that same dashboard to check in/out books.
I wanted to give each book its own QR code or barcode to ensure there were no typos when checking in/out a book, but some of the books were very old and we didn't want to risk damaging them. We have been discussing other options such as barcodes for most of the books and contacting the librarian to check in/out any of the books that didn't have barcodes.
Additionally, we had a dedicated tablet so that even those without a smartphone could take advantage of it and it gave the library a central location to manage everything via a separate sign-on.

very well done!!! Thanks. That gives me some ideas.

Paul Newcome · 08/31/21

Always happy to help. 👍️

Smartsheet Basics

Smartsheet Basics

Barcodes and UPC's

Best Answer

Answers

Quick Links

Categories

Trending in Smartsheet Basics

Conversations in Sheet vs Report (for the Sheet)

Looking for Guidance on Smartsheet Aligned Solution Professional Certification

Conditional Formatting