Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoYes, In general this is possible. The QR code could be the URL link to display the appliance record. While any smart phone can recognize a QR code natively through the camera app, in my experience, using a reasonably priced low cost app from the Apple App Store or Google play there are QR code readers which seem to latch onto the QR code in a blink of an eye, thus providing a much better user experience.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Once the user has landed on the record, then you can have buttons on that record to navigate to useful places or display reports.
I think the short answer is yes QuickBase is a good tool for this sort of field maintenance work but to be able to scope how big a project it would be to get a brand new app launched would take a one on one discussion.
I think the short answer is yes QuickBase is a good tool for this sort of field maintenance work but to be able to scope how big a project it would be to get a brand new app launched would take a one on one discussion.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
ColemanDuCharme
4 years agoQrew Trainee
Hey Mark,
Thanks for getting back to me. I figured that would be what the overall structure looked like - but I didn't know you could add buttons within an individual record that could redirect you anywhere. Very helpful to know. Is there a good resource for understanding how to create and attach individual QR codes to a record within quickbase? I have seen other threads involving QR code creation and it seems like it has to do with using RTF formulas, but I am out of my element using them. Any pointers?
------------------------------
Coleman DuCharme
------------------------------
Thanks for getting back to me. I figured that would be what the overall structure looked like - but I didn't know you could add buttons within an individual record that could redirect you anywhere. Very helpful to know. Is there a good resource for understanding how to create and attach individual QR codes to a record within quickbase? I have seen other threads involving QR code creation and it seems like it has to do with using RTF formulas, but I am out of my element using them. Any pointers?
------------------------------
Coleman DuCharme
------------------------------
- MarkShnier__You4 years ago
Qrew Legend
There is a pretty good discussion thread here.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=cc93d241-8a16-4422-b47c-97445edbd3f7&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bmcc93d241-8a16-4422-b47c-97445edbd3f7
Here is the essential code that you can try
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)
& "\"\"/>"
You will note in the discussion thread that the community typically uses the free utility from Google which is in the URL above. Because it is free that does mean there is a risk it could stop working at any time. My Plan B would be to scramble and go to Trinity https://trinityis.com/ for a replacement solutions.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------