I'd like to create a QR code that pulls up a record in the QB app on a tablet when scanned with the tablet's camera app. This QR code would be a field in my Packing List table. When the packing list is printed out by our office staff, the QR code will be printed as well.Our warehouse team would like to scan the QR code and be taken straight to the record of the packing list in the QB app on their tablet instead of looking for the record in the app.I've had some success generating QR codes but having trouble directing to a record. Here's my code for the QR code."<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=120x120&chl="&[QR Code URL]&"\"alt=\"\"/>"where [QR Code URL] is 'https://cfkent.quickbase.com/db/bpc9xkysz?a=dr&rid=[Record ID#]------------------------------Howard Fu------------------------------

I'm just doing this with a client now and its working amazingly well.Here was my code for a formula Rich Text fieldvar text URL = URLRoot() & "db/" & [_DBID_LINE_STATUS_UPDATES] & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode ([Record ID#]);"<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=240x240&chl="& URLEncode($URL)& "\"\"/>"so in your case it should just bevar text URL = URLRoot() & "db/" & dbid() & "?a=dr&rid=" [Record ID#];"<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=240x240&chl="& URLEncode($URL)& "\"\"/>"I also found that the native camera on the iPhone didn't give enough visual, haptic or auditory feedback. After a bunch of surfing the best free app that I found in the App Store for iPhone was called QR Scanner with a green icon. These apps all have very similar names. This one was by Kaspersky. It has some pop up ads but they were not too annoying. For different reasons I also owned an app called pic2shop pro. That worked very well indeed and it has no ads but it costs $24.99 (one time purchase) in Canada. Using an app was way better than just the native camera because you get crazy good visual haptic and auditory feedback when the QR code is acquired. Anyone has some other scanning apps they can suggest or perhaps apps that are specific to android which I was not able to test it would be great if they posted that here. Part of my testing of a bunch of App Store scanning apps involved finding an app which had the minimum number of clicks after you acquire the scan to get back to being ready to do the next scan. In both cases for the apps I mentioned it is only one click to get back to the screen to take the next scan and you really can't get fewer clicks than one.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Thanks Mark!. You've come through once again! Greatly appreciated!------------------------------Howard Fu------------------------------

I am wanting to do the same but getting an error that my Record ID # is not compatible iwth field type. here is my code for rich textvar text URL = URLRoot() & "db/" & dbid() & "?a=dr&rid="[Kit ID#];"<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=240x240&chl="& URLEncode($URL)& "\"\"/>"------------------------------Bob Salaj------------------------------

nevermind. missed the &------------------------------Bob Salaj------------------------------

Does this automatically use the app for you, or use the web browser? I have QR codes that take a user to the record, but I never did get it default to the app. It opens a browser, which works but is not desirable.Actually, it seems to go to the app on iOS but not Android. Interesting...------------------------------Mike Tamoush------------------------------

QR Code to access record in QB App

18 Replies

MarkShnier__You
Qrew Champion
4 years ago
I'm just doing this with a client now and its working amazingly well.

Here was my code for a formula Rich Text field

var text URL = URLRoot() & "db/" & [_DBID_LINE_STATUS_UPDATES] & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode ([Record ID#]);

"<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=240x240&chl="
& URLEncode($URL)
& "\"\"/>"

so in your case it should just be

var text URL = URLRoot() & "db/" & dbid() & "?a=dr&rid=" [Record ID#];

"<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=240x240&chl="
& URLEncode($URL)
& "\"\"/>"

I also found that the native camera on the iPhone didn't give enough visual, haptic or auditory feedback.

After a bunch of surfing the best free app that I found in the App Store for iPhone was called QR Scanner with a green icon. These apps all have very similar names. This one was by Kaspersky. It has some pop up ads but they were not too annoying.

For different reasons I also owned an app called pic2shop pro. That worked very well indeed and it has no ads but it costs $24.99 (one time purchase) in Canada. Using an app was way better than just the native camera because you get crazy good visual haptic and auditory feedback when the QR code is acquired.

Anyone has some other scanning apps they can suggest or perhaps apps that are specific to android which I was not able to test it would be great if they posted that here.

Part of my testing of a bunch of App Store scanning apps involved finding an app which had the minimum number of clicks after you acquire the scan to get back to being ready to do the next scan. In both cases for the apps I mentioned it is only one click to get back to the screen to take the next scan and you really can't get fewer clicks than one.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- HowardFu
  Qrew Cadet
  4 years ago
  Thanks Mark!. You've come through once again! Greatly appreciated!
  
  ------------------------------
  Howard Fu
  ------------------------------
- BobSalaj
  Qrew Member
  4 years ago
  I am wanting to do the same but getting an error that my Record ID # is not compatible iwth field type. here is my code for rich text
  
  var text URL = URLRoot() & "db/" & dbid() & "?a=dr&rid="[Kit ID#];
  
  "<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=240x240&chl="
  & URLEncode($URL)
  & "\"\"/>"
  
  ------------------------------
  Bob Salaj
  ------------------------------
  - BobSalaj
    Qrew Member
    4 years ago
    nevermind. missed the &
    
    ------------------------------
    Bob Salaj
    ------------------------------
- MikeTamoush
  Qrew Commander
  2 years ago
  Does this automatically use the app for you, or use the web browser? I have QR codes that take a user to the record, but I never did get it default to the app. It opens a browser, which works but is not desirable.
  
  Actually, it seems to go to the app on iOS but not Android. Interesting...
  
  ------------------------------
  Mike Tamoush
  ------------------------------
  - MarkShnier__You
    Qrew Champion
    2 years ago
    For my client situation we use the web interface.
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------