Forum Discussion

JulieMeeker's avatar
JulieMeeker
Qrew Cadet
3 years ago

Generating QR Code with URL to record

I am trying to generate a QR code that will open a record in Quickbase.  I have a Formula URL field that generates the URL: URLRoot() & "db/" & [_DBID_ASSETS] & "?a=dr&key=" & URLEncode([Cart ID#])...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
I'm using this syntax

var text URL = URLRoot() & "db/" & [_DBID_ASSETS] & "?a=dr&key=" & URLEncode([Cart ID#]);

"<img src='http://chart.googleapis.com/chart?cht=qr&chs=240x240&chl="
& URLEncode($URL)& "'>"

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
BaileyDesormeau's avatar
BaileyDesormeau
Qrew Member
2 years ago

Hi Mark,

I am trying to have a qr code generated and scannable. Right now when I put the QR code field in the main form it is showing as broken. Here is my formula rich text: 

var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [BOL ID#];

"<img src=\"https://chart.googleapis.com/chart?cht=qr&chs=240x240&chl="
& URLEncode($URL)
& "\"\"/>"

Also here is a snippet of what the field looks like in a form, shouldn't the qr code be visible here?

Thanks so much,
Bailey Desormeaux

  • MikeTamoush's avatar
    MikeTamoush
    Qrew Elite
    2 years ago

    Is BOL ID# your key field? If you switched the key field from [Record iD#], you will need to use the syntax Mark posted ("...&key=" & URLEncode([BOL ID#]))

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago

      Here is syntax that also works for me.  I found that the Google AI was not reliable.

       

      var text URL = URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]);

      "<img src=https://quickchart.io/chart?cht=qr&chs=150x150&chl=" & $URL & "</a>"