Forum Discussion

Qrew Trainee

4 years ago

Capabilities of QR code usage within quickbase.

Our organization would like to attach QR codes to outdoor appliances across several locations. Ideally, a technician could then scan that QR code and have that appliance's record pulled up, along with...

APIs and custom code

Formulas and functions

ColemanDuCharme

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

MarkShnier__You

Qrew Legend

4 years ago

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