Best way/app to use scanner for checking in and out products that already have bar codes on them. Basically like a library check in and out system that uses a scanner?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I want to use or create an app that allows me to track products by checking them in and out with a scanner.

Photo of Derek

Derek

  • 30 Points

Posted 4 years ago

  • 0
  • 1
Well, the low tech solution is to simply scan the bar code into  the input box of an <ask the user> report or even a Dashboard search box, and update who has borrowed the Product.

But I would guess that you are looking for a log history of who has had the item.  So that would simply require a child table to the Products table to record the movements of the Products.  You would then do a summary field on that relationship of the maximum record ID and then a reverse relationship to get the most current location of the Product floated up to the Parent Table.
Photo of Derek

Derek

  • 30 Points
Yes this would be helpful.  Although would it support checking in many items at once?  For example I want to check out 60 laptops quickly by just scanning them and them be able to check those 60 laptops back in a few days later.  What would be the best approach for this? It's really to nail down if we are missing any laptops at time of check in and alerts us which one.
Photo of Akhilesh

Akhilesh

  • 12 Points
Quick Question on this - How do you scan a bar code into the input box? Are you suggesting the input box to be a file attachment field or is there process which connects an actual hardware scanner into the app wherein the scanner converts the barcode into digits and stores it in the input box

Would really love to get some clarity on this
There are low cost scanners which are often called wedge scanners.  They simply go (ie wedge) in between the keyboard and the computer, so when you scan it's as if you typed off the keyboard into the input box.  The computer has no idea who did the "typing"', the human or the scanner.
Photo of Akhilesh

Akhilesh

  • 12 Points
That explains a lot. Thanks

I would like to follow this up with another question. How can I can scan a barcode off of images through the QuickBase app. Could you tell me which would be a feasible option:
1. Have an in-built barcode scanner in the mobile device/ipad taking the picture and get the barcode data into the app when taking a picture.
2. Upload pictures containing barcode and build a formula or process in QuickBase to decode the image to obtain the barcode data

Although the second option sounds impossible, I would like to know your thoughts on the above two methods
I have no idea.  i suggest that you post this as a new question.
Photo of Derek

Derek

  • 30 Points
I would be using a scanner attached to my laptop.