Forum Discussion
Your post and Marks post finally sparked a solution in my mind. I have Juiced EFP. In juiced EFP I can produce a child table shown on my output pdf. I can just utilize that, and make a parent to all my records in a dummy table or any other way. In fact, I need to look closer at Marks link, that is probably how their mail merge button push works.
------------------------------
Mike Tamoush
------------------------------
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
------------------------------
- MikeTamoush2 years agoQrew Commander
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
------------------------------- KeithJusas2 years agoQrew Captain
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
------------------------------- MikeTamoush2 years agoQrew Commander
Thats awesome news Keith! I'll look for that update in the coming months.
------------------------------
Mike Tamoush
------------------------------