Forum Discussion

KeithJusas's avatar
KeithJusas
Qrew Captain
2 years ago

Re: I've created a QR Code, now how to I print them all?

Mike,

Exact Forms Plus can generate QR Codes using a function in the template itself

click link below to a record in our demo app: https://juicedtech.quickbase.com/db/bknf8jnve?a=dr&r=g&rl=zcf 

Scroll right to the Labels tab and click the Create Task Labels button.

some of the parameters in the formula code of the button

clientid=Q999"
& "&appid=" & AppID()
& "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES]
& "&tpid=41"
& "&fn=Lbl"
& "&msdb=" & [_DBID_TASKS]
& "&docfmt=pdf&stream=y"
& "&mrgdbid=" &Dbid()
& "&mrgrid=" & [Record ID#]
& "&mrgfn=lbls"
& "&mrgfa=345"
& "&msqry={'48'.EX." &[Record ID#] & "}");

Attached is the document template and the labels pdf

The field in the task table, field id 149, is a formula URL field with the following value so when the QR Code is scanned it will display the Task record
URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Task ID]

More info on Barcodes for EF+
http://qbtools.helpdocsonline.com/exactformsplus-barcodes

------------------------------
Keith Jusas
------------------------------

4 Replies

Sort By
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    2 years ago

    Thanks Keith! I'll take a look. This could likely work, though I know we were trying to get our logo in the middle, which I have created but would need to use my custom link in order to print that, which is my my head went towards using EFP utilizing the embedded report feature. EFP has so many features, it's hard for me to keep up! :)



    ------------------------------
    Mike Tamoush
    ------------------------------
    • KeithJusas's avatar
      KeithJusas
      Qrew Captain
      2 years ago

      Hi Mike,

        I wanted to share an update...I  looked into the ability to include a logo in the middle of the QR Code that we generate in Exact Forms Plus and it looks like we will be able to do that.  Won't be available until April/May though, I'll keep you updated.  



      ------------------------------
      Keith Jusas
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander
        2 years ago

        Thats awesome news Keith! I'll look for that update in the coming months.



        ------------------------------
        Mike Tamoush
        ------------------------------