Forum Discussion

JuanSolorio1's avatar
JuanSolorio1
Qrew Cadet
11 months ago

QR code to add new record

Hello everyone,

I have a table that stores equipment items, and there's a field that stores a QR code for each item. These QR codes are also printed on labels and affixed to their corresponding equipment item.

Users perform inspections on these equipment items daily. The goal is to have users walk up to a piece of equipment and scan it, and this would launch the inspection form in QB in add mode, with the equipment item already filled out or selected.

I know that we can already accomplish this with the QB app. However, many users will not be registered QB users simply because it's pointless to add them and pay for a license when all they'll ever do in QB is fill out these forms. Since they won't be registered users, they won't be able to use the app.

 Note that we already have the relevant table available to "Everyone on the internet". We just need to be able to incorporate the scanning functionality.

Any suggestions are welcome and appreciated!



------------------------------
Juan Solorio
------------------------------

5 Replies

  • If you have that table set with Permission to Add for the EOTI Role, then they should be abe able to scan a QR code to Add Record.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JuanSolorio1's avatar
      JuanSolorio1
      Qrew Cadet

      Hi Mark,

      Non-registered users will be accessing the form via a link. Unfortunately, the scanning icon does not show up for them when the user doesn't have the app installed. It forces them to select from the drop-down list.





      ------------------------------
      Juan Solorio
      ------------------------------

      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger

        I'm trying to understand your question.  I think you are saying that your registered users are using the Mobile App from the App Store or Google Play and the Mobile App can scan a Bar Code or QR code to fill in a field. 

        You are asking if there is a way for non users to use the Mobile App.

        This forum question (by me!) was answered by the then Mobile Product Manager at Quickbase. Alice says that it's possible use the Mobile App for an EOTI user. 

        I tried to do a test by scanning a QR code with my iPhone camera which would put up an Add Record Form  (?act=API_GenAddRecordForm.......  But even though the table was set up with permissions to allow the EOTI Role to View and Add records, I got blocked at the sign in page on the mobile app.

        Maybe try a support ticket referencing that Forum post by the QB Product Manager, and I will keep thinking about this.   



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------