Capabilities of QR code usage within quickbase.

ColemanDuCharme
Qrew Trainee
4 years ago
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
  ------------------------------
ColemanDuCharme
Qrew Trainee
4 years ago
For reference, I am trying to use the RTF that you provided in this thread to generate a unique QR code for each record in a table: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=a3392d8b-8c26-4a98-acde-635f3b91ad51&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer.

Because I have no idea what I am doing with RTFs, I get the error "the field [record ID#] is not compatible with the parameter field type". Can you point me in the right direction?

------------------------------
Coleman DuCharme
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  Coleman,
  There are a few of us on this form that are happy to help you debug formulas. What you need to do is copy and paste the actual text of your current formula as well as a copy and paste or a screenshot of the error message and then we can help. The most important thing is a copy and paste of your code because we cannot correct a screenshot.
  
  Also let us know what field type the formula is in.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - ColemanDuCharme
    Qrew Trainee
    4 years ago
    Thanks Mark,
    
    I will check out the thread linked and see if I can't solve my own problem using that as reference. I will provide a screenshot + copy of code as well as the field type used if I run into any more problems.
    
    ------------------------------
    Coleman DuCharme
    ------------------------------

Forum Discussion

Capabilities of QR code usage within quickbase.