QR Code to access record in QB App

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
------------------------------