Forum Discussion

ColemanDuCharme's avatar
ColemanDuCharme
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's avatar
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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's avatar
    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
    ------------------------------
  • ColemanDuCharme's avatar
    ColemanDuCharme
    Qrew Trainee
    4 years ago

    Hey Mark, that thread was immensely helpful. I used the rich text field formula you provided and now it is spitting out QR codes related to each record. Next step is figuring out how to turn the record field that the QR redirects to into a usable page with buttons that technicians could use simply. We are finally making some progress over here.

    ------------------------------
    Coleman DuCharme
    ------------------------------