Thats awesome news Keith! I'll look for that update in the coming months.
Original Message:
Sent: 03-13-2023 13:31
From: Keith Jusas
Subject: I've created a QR Code, now how to I print them all?
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
Original Message:
Sent: 03-10-2023 10:13
From: Mike Tamoush
Subject: I've created a QR Code, now how to I print them all?
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
Original Message:
Sent: 03-09-2023 22:17
From: Keith Jusas
Subject: 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
Original Message:
Sent: 03-09-2023 19:35
From: Mike Tamoush
Subject: I've created a QR Code, now how to I print them all?
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
Original Message:
Sent: 03-09-2023 19:26
From: Tyler Jablonski
Subject: I've created a QR Code, now how to I print them all?
I can think of at least one way to do this in native Quickbase, but it's extremely inconvenient. Also on mobile right now, so I can't type out all of the formulas.
In whatever table houses the QR codes, you can create another rich text formula field that just encompass the existing QR code field in a <td> tag. We can call this [QR Container].
Then you can have a formula query field that uses size() and getrecords() to find the number of QR code records with a record ID# less or equal to that record. So Record ID# 1 will return 1, Record ID# 2 will return 2, etc. I'll call this [Lower RIDs].
Then you have another formula query field. Let's say you want the printed copy to have 4 QR codes per row. If the [Lower RIDs] value is divisible by 4, it uses getfieldvalues() and getrecords() to collect the [QR Container] values of all records where [Lower RIDs] is greater than or equal to that record's [Lower RIDs] value minus three, but lower than or equal to that record's [Lower RIDs] number. So RIDs 1-3 would return blank values (not divisible by 4), and RID 4 would return a list of the [QR Container] fields for RIDs 1 through 4. You can use searchandreplace() on this value to replace " ; " with "", which will give you an HTML string. You can then encompass this string in a <tr> tag. We can call this field [Table Row].
Finally, you have a formula query field that gets the values of [Table Row] for every record where it isn't blank. Then you use searchandreplace() on this field to replace " ; " with "". This gives you another HTML string, which you encompass in a <table> tag. We can call this [Table].
Then you add an Exact Form for the QR codes table that only includes "~fid~", where fid is the field id# of your [Table] field. This will give you a button on every record that when clicked, will give you a big Exact Form with a table of all of your QR codes that you can print. I have done similar things to this in the past, and I know that rich text fields will render properly in the Exact Form (including images like your QR codes).
Just writing this out, I'm sure it's terrible performance wise. There are definitely ways to optimize this by say, only having your fields make a table of the previous 100 records. So if you click on the button on your most recent record, you'll get your 100 most recently generated QR codes, but you won't be pulling together as much data as many times. Or maybe you only populate [Table] on the 5 most recent records, and if it's older than that it just returns a blank value.
Realistically, the easiest way to do this is with a code page, but that comes with its own set of headaches. And if you're not already comfortable writing JS code, it really isn't worth learning it just for Quickbase. They offer so many great no code tools that are easier and faster for 99% of use cases, that the time spent learning wouldn't justify itself for the limited number of times you'd use it. If this functionality is really important I'd recommend just going with the tedious native QB solution.
------------------------------
Tyler Jablonski
Original Message:
Sent: 03-09-2023 17:49
From: Mike Tamoush
Subject: I've created a QR Code, now how to I print them all?
Thanks Mark. Unfortunately, the native solution is only for text. There are some resources to get an image, but the last 4 hours of trying for me have failed. I think the Juiced solution will also utilize text only, but I'll look into it! Thanks. Otherwise, I maybe have to go to a QR code site, import my URLS and use their native software to download everything as image files? Perhaps?
Im still researching. Hopefully someone in the community has already figured this out!
------------------------------
Mike Tamoush
Original Message:
Sent: 03-09-2023 17:20
From: Mark Shnier (Your Quickbase Coach)
Subject: I've created a QR Code, now how to I print them all?
Great Demo App here from Juiced for either a native or a Juiced EF+ solution.
https://juicedtech.quickbase.com/db/biji85xs9
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-09-2023 16:19
From: Mike Tamoush
Subject: I've created a QR Code, now how to I print them all?
I've used techniques I found in the community to create a reach text field that shows an image of a QR Code. It looks perfect, every record has it's own unique QR code. Now I am stuck - how to I physically print these out? I was trying to figure out how to possibly use mail merge in word, so I could put them on say Avery labels?
I know I could cheat by taking a screen shot, saving as an image, and printing, but that obviously isnt a real solution (I have 500+ to print). How have people gone about printing?
------------------------------
Mike Tamoush
------------------------------