Discussions

Expand all | Collapse all

QR Codes

  • 1.  QR Codes

    Posted 25 days ago
    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 assets, what is the best practice in doing this? Below is my current thought process, but I might be coming at it wrong. I think I am misunderstanding a fundamental principle, because I don't know how I utilize the new QR code function within QB.

    1) Print out sheets of QR codes onto weather proof labels. Both developing the QR codes and labels would be independent of Quickbase.
    2) Field tech applies a sticker to an asset. Takes a picture of the sticker and uploads that as a file attachment to Quickbase. 
    3) Field tech fills out Serial  Numbers, attaches more pictures, etc etc.
    4) Manager (or anyone party logged in from computer responsible for QR codes) changes the dynamic QR code link to say, the url for that particular asset.
    5) Any time someone needs the info on the asset, scan the QR code sticker on the asset.

    That's where I am at, what am I missing...?? What is the intention for the new QR option in the mobile QB app?

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: QR Codes

    Posted 25 days ago
    The purpose of the Bar code / QR code reading is so you can do the data entry of the bar code value into a field on the mobile app.  I doubt that you want to take a picture of the bar code. More likely you want to locate the asset off an existing asst or else or create the asset record, then affix the sticker and do the code data entry via the mobile app.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



  • 3.  RE: QR Codes

    Posted 25 days ago
    So tech sticks on a sticker, creates a new asset. How does he relate the asset to that sticker?

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: QR Codes

    Posted 25 days ago
    He 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
    ------------------------------



  • 5.  RE: QR Codes

    Posted 25 days ago
    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
    ------------------------------



  • 6.  RE: QR Codes

    Posted 24 days ago
    Typically 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
    ------------------------------



  • 7.  RE: QR Codes

    Posted 24 days ago
    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
    ------------------------------



  • 8.  RE: QR Codes

    Posted 24 days ago
    Yes, 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
    ------------------------------