QR Codes
I'm just starting a thread to try to get some input/discussion on the fundamental implementation of using QR codes for asset tracking, within Quickbase. If i have a field tech that is going to catalog...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHe will edit the asset record and scan the code into the code field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Perhaps my understanding of the Barcode is wrong. The way I picture it, when you create the Bar Code, there will be a link or data associated with it. Let's say generically we print out 500 bar codes with the numbers 1,2,3,4...500 associated.
When the tech sticks the code on the asset,and scans the code, won't all that will happen is it will put the number '1' into the field he scans with?
I need him to then enter other information, change the detail associated with that code, and also have an image of that code associated with that item. I'm not seeing how all that would be accomplished.
------------------------------
Mike Tamoush
------------------------------
When the tech sticks the code on the asset,and scans the code, won't all that will happen is it will put the number '1' into the field he scans with?
I need him to then enter other information, change the detail associated with that code, and also have an image of that code associated with that item. I'm not seeing how all that would be accomplished.
------------------------------
Mike Tamoush
------------------------------
- MarkShnier__YouTypically bar codes are ugly to human enter due to their length. So the purpose of scanning a bar code, indeed, is simply to get an ugly long number into a data entry field, error free.
If you have a business purpose to uploading an image of the asset or for some reason an image of the bar code tag (i can't understand why, but that's up to you), then sure you can also upload pictures either into a child table of pix for that asset or to dedicated fields on the asset record. If are gong to have a variable number of pics for an asset record, a child table is a better way to go. There are ways to display thumbnails of the images even if they are child records, and even to float up the images to to the Parent record if you need to.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- It just clicked. I've been thinking that I would have to associate my own number with the barcode (QB record ID or something). So when I had a tech put the sticker on, I was picturing needing to re-associate that sticker with a new data field. Which I think could only be done by getting dynamic bar codes, and having some cumbersome data entry.
Instead, I'm thinking I just need to buy a roll of pre-determined bar codes. Those will all be coded with long ugly numbers. Scan that number in and done. Maybe I even set that bar code field as my key field.
I could probably make a form that is visible by 'Everyone on the Internet' that was just a search, and some data fields. Then anyone could take a picture of that barcode and access QB app, and see the product details and pictures. Or, if the person on site (not associated with our company) needed us to come out for the asset, they could just snap a picture of the bar code and send it to us. We could search for it in any number of ways (with the QR reader, or just enter the number if we want to be cumbersome).
Am I getting it?
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouYes, I think that you are getting it. The asset # can just be a sequential number.
It is a different challenge to have a QR code that will call up the asset record, as to do that, you would need to also encode and print in the QR code for the complete the access path to view the record.
The simple for URL formula field to display a record in Quick Base would be
URLRoot() & "db/' & dbid() & "?a=dr&key=" & [asset#]
So before we go off an generate a spool of sequential Bar Codes we need to think through the strategy if the goal is to be able to read a QR code to go to a website (ie your app).
If you hold a smart phone camera up to a QR formatted to go to a website https://www.digitaltrends.com/mobile/how-to-scan-a-qr-code/ then it will easily guide the user there, but that is a different content in the code than the pure bar coded numbers.
As you might infer from the formula above, the actual asset# is just the past part of the full
https:// mycomany.quickbase.com/db/xxxxxx?a=dr&key=123456789
web path to display the record.
So we would need a simple linear bar code to do the data entry and another QR Code to have a user scan to display the record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------