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