Skip to main content
Question

QR Code to access record in QB App

  • January 18, 2021
  • 0 replies
  • 458 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement